Inserting records into tables using Unicode

[yaakov]

Hello!

I insert into table some records. I wrote it in Hebrew. When i retrieve it i got question marks. I understand that i have to use unicode but how?

The INSERT code was

INSERT INTO table_name (field1,field2)
VALUES ('value1 in Hebrew','value2 in Hebrew')


The result to the query "SELECT * FROM table_name"
was field1 field2
????? ??????

Thank you
Yaakov from Israel

 

[foxdev]

Did you define the character columns as NCHAR and/or NVARCHAR?
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[TomSark]

Hi Yaakov from Israel,

What code page and unicode collation are you using on the server (I'm assuming you are using SQL Server 7.0).

Also, you should use N in front of the quote to force a string literal to unicode:
INSERT INTO table_name (field1,field2)
VALUES (N'value1 in Hebrew',N'value2 in Hebrew') -- note the N

Hope this helps.. let me know...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com