RE: Asking again - ResultSet.getString() & unicode

Ok, here's some interesting results:

First, please keep in mind that if I use hibernate (www.hibernate.org) I can
insert and select with no problems on my system. So I don't think it's a
configuration issue but instead some setting needed.

If I add the N then it inserts fine. Obviously this doesn't help in the
select.

If I create a database using BOPOMOFO for the collation, then if I insert
without the N, the chinese character inserts correctly, but the russian
character does not. The select still fails for both characters.

So I think the answer for an insert is to use the N'unicode_string' as that
solves that problem. But to select, I still can't get it with
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE)

Any further ideas?

--
thanks - dave


"Steven Cheng[MSFT]" wrote:

> Hi Dave,
>
> I still think the problem should be environment specific since on my local
> environment, no matter I use
>
> Statement stmt = conn.createStatement();
>
> or
>
> Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.CONCUR_UPDATABLE);
>
> I can get the unicode string correctly from sqlserver. Also, for inserting,
> I can directly insert unicode in the following style:
>
> "\u98a8";
>
> What's your database's Collation setting? Though from my test , this
> doesn't change the result, I think you can try set the collation to a
> codepage which can correctly interpret the wide chars. In addition, in
> T-SQL, when we inserting unicode string, it's recommended that we add "N"
> Prefix for each string value, so you can try using the following insert
> statement to see whether it can insert unicode correctly:
>
> public static boolean InsertNewUser (String name, String email) throws
> Exception{
>
> Connection conn = getConnection();
>
> String sql = "insert g_user values(N'" + name + "', N'" +
> email + "')";
>
> ....................................
>
> }
>
>
> Hope helps. Thanks,
>
> Steven Cheng
> Microsoft Online Support
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --------------------
> | Thread-Topic: Asking again - ResultSet.getString() & unicode
> | thread-index: AcW1eMlyyC/Dmw/1QQyoC1z0+TfdCA==
> | X-WBNR-Posting-Host: 199.45.247.98
> | From: "=?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=" <thielen@xxxxxxxxxxxxx>
> | References: <CEFAD23A-E1BA-479B-9923-511D6FDCE30A@xxxxxxxxxxxxx>
> <7PGnYcEtFHA.1252@xxxxxxxxxxxxxxxxxxxxx>
> <B25E4840-9D02-4372-A9FE-0DCD48456968@xxxxxxxxxxxxx>
> <mrGDGPRtFHA.768@xxxxxxxxxxxxxxxxxxxxx>
> <10F8AE17-DDB4-41B8-8D74-783D97E9E80F@xxxxxxxxxxxxx>
> | Subject: RE: Asking again - ResultSet.getString() & unicode
> | Date: Fri, 9 Sep 2005 12:58:03 -0700
> | Lines: 10
> | Message-ID: <181272BD-5477-4ECC-94C2-EF3D54A0C08F@xxxxxxxxxxxxx>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.odbc
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2691
> | X-Tomcat-NG: microsoft.public.sqlserver.odbc
> |
> | Sometimes a picture shows things a lot better so you can find your code
> with
> | some minor changes I made, and screen shots of the database at
> | http://www.windward.net/jdbc2.zip
> |
> | Note that the first row I inserted by hand - it was not created by your
> | program.
> |
> | --
> | thanks - dave
> |
> |
>
>
.

Relevant Pages

  • Re: Unicode characters in string table
    ... stringtable string. ... I've tried inserting it in the resource editor, with no luck, so I've ... Is the program defined with _UNICODE and UNICODE so that it uses unicode text? ...
    (microsoft.public.vc.mfc)
  • Re: Problem with Fonts continue
    ... >Unicode take two bytes per char to write characters from many languages in same string. ... I cannot answer why Microsoft did this, ... VB6 has builtin translation (Unicode to ASCII) for passing string to API. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Unicode characters in string table
    ... stringtable string. ... I've tried inserting it in the resource editor, with no luck, so I've ... Seems like saving the .rc as Unicode made it work properly. ...
    (microsoft.public.vc.mfc)
  • Unicode characters in string table
    ... I want to add a math symbol (increment symbol, unicode 0x2206) to a ... stringtable string. ... I've tried inserting it in the resource editor, with no luck, so I've ...
    (microsoft.public.vc.mfc)
  • Re: Tranfering unicod charcters in Socket programming!
    ... You are telling about conversion b/w MBCS to Unicode. ... If this is not possible Shall I try with string to wstring ... int SendStringAsUnicode ...
    (microsoft.public.win32.programmer.networks)
Quantcast