Unicode data in oracle database shows "?" question marks...........

Last post 07-23-2008 10:40 AM by greg.darling. 4 replies.

Sort Posts:

  • Unicode data in oracle database shows "?" question marks...........

    07-02-2008, 5:45 AM

    I have installed oracle database on a Linux base server.

    Now if I run my asp.net application, which is on windows XP system, which is accessing the

    above mentioned database then everything goes fine. I can easily store Unicode data in correct form.

                 But if I run my application using Windows Server 2003 then the unicode data saved by the

    application shows "?" question marks in database.

    .

    .

    .

    Does this problem is windows version specific or anything else?????

    Does anyone have the solution???????? 

     

  • Re: Unicode data in oracle database shows "?" question marks...........

    07-02-2008, 7:51 AM
    • All-Star
      22,266 point All-Star
    • vik20000in
    • Member since 12-30-2005, 6:02 AM
    • Kolkata
    • Posts 3,464
    • TrustedFriends-MVPs

    This is the [problem with the encoding used. Chnage you encoding to UTF8 so that the the data does not changes

    Vikram
    www.vikramlakhotia.com


    Please mark the answer if it helped you
  • Re: Unicode data in oracle database shows "?" question marks...........

    07-02-2008, 8:31 AM

     Yes, exactly you are right Sir.

    I have already changed the characterset in regedit > HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE_CLIENT 

     But that is the solution for hanging "?" (Inverted question mark).

    .

    .


    My problem is straight/correct question mark.....

    which I think could because of windows version.

    Does my approach in correct way???????/ 

    .

    .

    .

    Thanks for replying soon... 

     

  • Re: Unicode data in oracle database shows "?" question marks...........

    07-23-2008, 6:02 AM

    Please help me If anyone have the soluition .............

     

  • Re: Unicode data in oracle database shows "?" question marks...........

    07-23-2008, 10:40 AM
    • Participant
      1,440 point Participant
    • greg.darling
    • Member since 02-07-2003, 6:50 AM
    • Posts 306

    Hi,

    What characters and/or language are you trying to insert?

    What is the characterset of your database?  (select * from nls_parameters where parameter like '%CHARACTERSET'; )

    Upside down question marks occur when the bits you've inserted down validly line up with a code point in the characterset you're using.

    Greg

     

Page 1 of 1 (5 items)