PDA

Click to See Complete Forum and Search --> : unicode

asabi
Sep 29th, 2000, 03:37 AM
I have a SQL 7.0 server configured to work with unicode (Hebrew Lang), and I try to make a Web Page that would put information in the DB.

I can insert Hebrew from the Query analyser using the insert command, but when I am using the ASP code, I get ???? instead of letters.

I am using the Unicode because I don't know of any other way to work with SQL with Hebrew...

1. If anyone one knows a better way, please say so.

2. If anyone knows how to convert the input from the webpage to proper SQL 7.0 unicode form or any ASP function that would do it ..


HELP ...
André
Sep 29th, 2000, 07:40 AM
Hi there, you must set your codepage to UTF-8

Good luck

André
asabi
Sep 29th, 2000, 11:26 AM
didn't help ..

this is what I get .. X|XX?X| instead of ŕěĺď ...

I prefer not to use unicode, because I will also need to show the information on a web page later (I suspect that's nother issue) ..

Any other idea ?
parksie
Sep 29th, 2000, 12:46 PM
See the WC3's spec on HTML entities - you can insert Unicode characters: http://www.w3.org
asabi
Sep 30th, 2000, 01:27 AM
It is still all fuzy ..

Maybe I can do it the other way around, can I make SQL working with multy language not with Unicode ?
parksie
Sep 30th, 2000, 04:14 AM
No, it's still best, I think, to use Unicode with MSSS. Then, when making the page, use something like:

<body>
Ӓ - here's a character
</body>

And yes, it's a little fuzzy. Proper internationalisation in computer systems hasn't arrived yet and probably won't for a few years.

Also, just found this: http://www.ietf.org/rfc/rfc1555.txt
asabi
Sep 30th, 2000, 10:01 AM
Thank you,

I will try :-)