tags:

views:

16

answers:

1

where i need to select char(253) and get ANSI character in Arabic collation dosent work

+1  A: 

Are you using the correct code page? ANSI is an extension of ASCII which contains characters from 0 - 127. ANSI codepages specify a range from 128-255 (top bitset characters) which can vary depending on the ANSI code page.

If you can - use UTF-8 - it'll make it easier for you in the long run.

Further reading on wikipedia.

Konrad