DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Quoted string not properly terminated

  1. #11
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    I,ve set NLS_LANG = slovenian_slovenia.EE8ISO8859P2 and it is working!

    There is no sign of "quoted string not properly terminated" error.

    But now I have the other problem. My nacional charachters requires two places in a string. So if field's length is 10 and I insert string which containts 5 our charachters plus one more that I get message "inserted value too large for column"

    What I would like to kwow is that normal. Becouse if that is normal I will just increase lenghts of varchar2 fields in database.

  2. #12
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    That is normal, your Slovenian character takes 2 bytes in UTF8 database, so in VARCHAR2(10) you can place only 5 characters.

    To know the size of string:

    select lengthb('?') from dual;

    Originally posted by Aljaz
    What I would like to kwow is that normal. Becouse if that is normal I will just increase lenghts of varchar2 fields in database.
    Best wishes!
    Dmitri

  3. #13
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width