how to get ansi character value form database where select char

Wher开发者_开发百科e I need to select char(253) and get ANSI character in Arabic collation doesn't work.

---

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.