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:

Code:

<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 :-)

Thread: unicode

Thread Tools

Display

Posting Permissions