Help !! Foreign language support.

[s...@prsn.com]

Help: Foreign language import in SQL7

I am having some problems with importing Foreign language text file
into SQL7.
I checked into the master database at syslanguage and Japanese fonts
does not show up in the localized version of data. Does anyone know
what to do in this case - to turn the settings on ? What kind of
configurations do i need to look at to check this ?

Much appreciated. Waiting for those who can help!!

SI E

[Neal Lowrey]

not sure this helps but..

The big deals for these type of things are code page, sort order, and
unicode. Through what mechanism are you trying to import?

Are the fields in the SQL table for the text fields set to nchar, nvarchar
for unicode types?

s...@prsn.com wrote in message <3741e011....@corp.supernews.com>...

[vor...@yahoo.com]

I'm getting the same exact problem. My problem is that when I pull a
query on the table I imported from a text file that I have verified
does contain AND show foreign language characters such as Japanese, it
shows up as high-order ASCII characters in return. I checked my tables
and indeed they have nvarchar types. I'm using the 850 code page
(multilingual) and the sort order I don't think is really imperative.

Anybody have experience with this particular issue?

-Howard-

In article <mpz03.424$DX.3...@eagle.america.net>,

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---

[sygi...@my-dejanews.com]

Thanks for your reply.

I have tried reselecting the code page, sort order and unicode. It still
doesn't work. I experimented with two code pages - first time, 1252 as
default, then 932 for default ( Japanese ) since I was trying to import
a flat Japanese text file. When I reconfigured both times, and went into
master.syslang to see if it would pull up Japanese fonts. It still
wouldn't/ I was really baffled.

Don't know what else to look at... if you do, please please let me know.
Thanks.