Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-02 : 10:07:39
|
| Burcak writes "I'm Turkish and our alphabet contains a few nonstandard letters that are derivation of standart letters, for example an s with a tail beneath.Using Access 2000 or MS SQL 7, I can store strings with Turkish characters in them and the database engines can do proper sorting. Therefore I conclude that the database DOES recognize Turkish letters.However, whenever I try to access the data through OBDC or OLEDB (web or even importing data into Excel), the returned strings are CONVERTED (not stripped) to standart letters, ie, the s loses its tail.I go back in and look at the data, do the query in the database, build forms, etc. the lettering is correct, however the output to other programs is wrong.I asked around, and the only reply I got was "That's why we're using MySQL, it doesn't have this problem." I refuse to believe this is a problem that cannot be solved.Any ideas?Regards,Burcak" |
|
|
|
|
|
SQL Character Conversion Problems