Re: Japanese to Unicode characters

From: Vital (av.perrey_at_orangemail.ch)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 16:38:53 +0100

Steve,

In fact it is not so easy...

I have 2 applications:
- the old one is working with OpenVMS on a VAX machine and uses an
Oracle-Rdb database; a VB application running on a Window98 Japanese PC
read/updates the database through an Oracle ODBC driver for Rdb; Rdb doen't
store the japanese strings as Unicode. To work with these strings it was
necessary to set the VB textbox Font to MS Mincho (with the Japanese
script).

- the new one is working on a Win2000 server and uses a SQL2000 dB. A VB
application running on the same machine read/updates the database. To work
with the Japanese strings (declared as NVarChar in SQLserver) we uses an
UniToolBox component for VB which handle the Unicode strings.

Now I want to migrate the data from the Rdb to SQLserver dB and store the
Rdb Japanese strings into Unicode SQLserver fields; but I cannot store them
as they are because they will not be understandable for the other Unicode
compatible tools (UniToolBox, CrytalReport, etc.) !

Any ideas?

"Steve Kass" <skass@drew.edu> wrote in message
news:41B08DB8.4050805@drew.edu...
> Vital,
>
> There's nothing special about storing unicode in a SQL Server table if
> you declare your column as nvarchar(-put suitable length from 1 to 4000
> here-). Unicode strings specified as literals must include the N
> indicator, as in N'unicode string here'. Is your question just "how do
> I store anything in a SQL Server database?" or are you having trouble
> with this particular kind of data?
>
> Steve Kass
> Drew University
>
> Vital wrote:
>
> >I have to migrate a Japanese application from Oracle-Rdb to SQL2000
> >database. I use an Oracle driver to get the japanese strings. To be sure
I
> >read correctly the values from the source database, I display the strings
in
> >a VB textbox with MS Mincho (Japanese script) font and this is fine.
> >
> >Now I want to store these strings into Unicode fields (nVarChar) in a
> >SQL2000 database... how?
> >
> >
> >
> >

Relevant Pages

  • Re: i18n hell
    ... table attributes to UTF-8 only garbage kept adding into the database. ... you using unicode strings or byte strings? ...
    (comp.lang.python)
  • Re: Japanese to Unicode characters
    ... It sounds like your existing Japanese data from the Oracle-Rdb database is ... migrate the data into Unicode columns in SQL: ... To work with these strings it was ...
    (microsoft.public.sqlserver.programming)
  • Re: Sqlite3 textfactory and user-defined function
    ... database from UTF-8 to unicode. ... I have a database that stores strings in 8-bit ISO-8859. ... the text_factory to do no conversion. ...
    (comp.lang.python)
  • Re: Japanese to Unicode characters
    ... Unicode strings specified as literals must include the N ... I store anything in a SQL Server database?" ...
    (microsoft.public.sqlserver.programming)
  • Re: VarChar VS. nVarChar
    ... Unless if you are already in the case of working in a near saturation level, ... will be easy or not later to change from ANSI to Unicode. ... database and cut in a half its performance. ... increase in storage and a performance decrease of about 10%. ...
    (microsoft.public.dotnet.framework.adonet)