LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Oracle DB not loading the Character sets correctly

    Employee
    Posted 02-16-2016 09:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dhrobertson

    Hi guys...

    I am loading data into an Oracle DB that has lots of descriptions that include special characters such as the Registered Trade Mark character (ascii code 169)
    I can see it in lavastorm output prior to load and in the source data which is in excel spreadsheets... however the special characters will not load into the DB...

    does something need changing on the DB side? I have tried changing the lavastorm data types from string to Unicode but nothing seems to work. the DB output just replaces the character with a "?"

    Is this a DB issue as the client is point a finger at Lavastorm...

    thanks

    Douglas


  • 2.  RE: Oracle DB not loading the Character sets correctly

    Employee
    Posted 02-16-2016 09:26

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    How is the column defined within the database?


  • 3.  RE: Oracle DB not loading the Character sets correctly

    Employee
    Posted 02-17-2016 05:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dhrobertson

    Originally posted by: stonysmith
					

    How is the column defined within the database?
    Hi Stony,

    the field is defined as VARCHAR2(100)

    regards

    doug