Unix Technical Forum

Unicode SQL Statements translated according to OS default locale ???

This is a discussion on Unicode SQL Statements translated according to OS default locale ??? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hello everybody, My Environment: - W2K with SP3, English default locale and Central Europe language group installed , - ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:13 PM
dan tudor
 
Posts: n/a
Default Unicode SQL Statements translated according to OS default locale ???

Hello everybody,


My Environment:
- W2K with SP3, English default locale and Central Europe language
group installed ,
- Microsoft SQL Server 2000 SP3 - SQL_Latin1_General_CP1_Cl_AS
collation

I have a Unicode application connecting to SQL Server through ODBC.
I created a database called şuţ (that is U+015F, U+0075,
U+0163 something like "sut" with cedilla under "s" and under "t").
When I try to "select name from sysdatabases" I get the correct
results.
If I try to use a parameterized statement, for example
"insert into MyTable (ColName) values (?)" and I bind the parameter to
the name specified above, everything is Ok.
The problem is that if I try to execute a (prepared or direct)
statement without parameters, like "use şuţ exec
sp_spaceused", the statement gets translated (I verified with the SQL
Profiler) into "use sut exec sp_spaceused" and it fails with error 911
"Could not locate entry in sysdatabases for database ‘sut'. No entry
found with that name. Make sure that the name is entered correctly."
Again, I compiled my application as Unicode and the statements are
Unicode strings, with the correct name

How can avoid that translation?

Any help would be greatly appreciated

Dan
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:14 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com