Russian and SQL Server or MySQL

[VicTci]

Hi,

Have a problem inserting and extracting russian characters into SQL
Server,MySQL database
Used CFMX 6.

Thanks,
Victor

[PaulH]

what encoding are you using? what datatypes for sql server? what ver of msql? are you using the JDBC drvers? for sql server see [url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url]

[VicTci]

....

> what encoding are you using?

windows1251

> what datatypes for sql server?

varchar

>what ver of msql?

2003 SP1

>are you using the JDBC drvers?

I try drivers "ODBC socket" & " MSSQL SQLServer" which present in the
CFMX6 without success
For Access driver "Microsoft Access with Unicode" work fine .

> for sql server see [url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url]

I not see information about work with DB

Thanks!

[PaulH]

confused, is your db access or sql server? if it's sql server, your text
columns has to be one of the "N" types (nText, nVarchar or nChar). look again
at that page, there's a "peek" link that shows how that page was done in cf. i
also didn't notice any russian text there. i guess you didn't try any part of
it.

[VicTci]

....

> confused, is your db access or sql server?

sql server.
But I test work with Access too .
Access & "Microsoft Access with Unicode" work fine with russian characters

> if it's sql server, your text
> columns has to be one of the "N" types (nText, nVarchar or nChar). look

again
Ok I try it.
It can work with
drivers "ODBC socket" or " MSSQL SQLServer" as well ?

Thanks!

[PaulH]

i don't recommend ODBC sockets for this sort of thing. JDBC should work better.
btw i would also suggest you go w/unicode (utf-8) instead of that windows
codepage encoding. it will save you some trouble in th long run.