CODER977
September 30th, 2005, 04:56 PM
hi,
I need to insert unicode text into MSSQL database through CGI (CGICC library) .
nvarchar (some_field);
when I execute this command
db.ExecuteSQL("INSERT INTO TABLE1 VALUES ('1',N'CROATIANLETTERSČĆŠĐŽ')"
I get only @#$^&&* in the MSSQL Enterprise manager.
DATABASE COLLATION SET TO CROATIAN.
What is the problem here? Do I need to convert the SQL string first?
I need to insert unicode text into MSSQL database through CGI (CGICC library) .
nvarchar (some_field);
when I execute this command
db.ExecuteSQL("INSERT INTO TABLE1 VALUES ('1',N'CROATIANLETTERSČĆŠĐŽ')"
I get only @#$^&&* in the MSSQL Enterprise manager.
DATABASE COLLATION SET TO CROATIAN.
What is the problem here? Do I need to convert the SQL string first?