Results 1 to 5 of 5

Thread: SQL - bp insert special characters with UPPER

  1. #1
    Join Date
    Oct 2008
    Posts
    89

    SQL - bp insert special characters with UPPER

    Hello

    I have little concern, as I explain below:
    I have to insert data into a database, data must be converted to uppercase.
    So far, so simple: INSERT UPPER ....

    The problem is that these data, I have special characters like '°', which after being capitalized are transformed into 'question in reverse.

    Someone is not how to avoid it, knowing that compulsion to insert the data in capitals must be respected?

  2. #2
    Join Date
    Oct 2008
    Posts
    29

    Re: SQL - bp insert special characters with UPPER

    is not a problem of encoding?

  3. #3
    Join Date
    Oct 2008
    Posts
    89

    Re: SQL - bp insert special characters with UPPER

    I think not.

    In fact, I retrieves data from a source, to put them in another basis (decision), the two databases using the same encoding. Unlike a base to another is that some fields are in capital letters (which is a constraints). And it was during this passage capitalized I explained the problem.

    I wondered for example, if there was not a SQL function (which I would not know) that 'leap-frog' the characters in the upper, or at least leave them as they are. I have not tested, but I think I have the same problem with accented characters, and the 'C', etc ...

  4. #4
    Join Date
    Jul 2008
    Posts
    92

    Re: SQL - bp insert special characters with UPPER

    Seen and approved ...

    Until someone finds the solution with UPPER, I suggest you use TRANSLATE:

    Code:
    SELECT TRANSLATE ( 'rastadd', 'abcdefghijklm', 'ABCDEFGHIJKLM') 
    FROM DUAL;

  5. #5
    Join Date
    Oct 2008
    Posts
    89

    Re: SQL - bp insert special characters with UPPER

    Good point, I will test it and see

Similar Threads

  1. Replies: 5
    Last Post: 23-12-2010, 07:12 PM
  2. How to insert special characters online forms in Mozilla Firefox?
    By Zhankana_n in forum Technology & Internet
    Replies: 5
    Last Post: 05-03-2010, 09:01 PM
  3. Not able to insert special characters in MAC
    By Adonis in forum Windows Software
    Replies: 5
    Last Post: 16-02-2010, 01:06 PM
  4. How to Insert Special Characters in JavaScript?
    By super soaker in forum Software Development
    Replies: 4
    Last Post: 02-02-2010, 05:16 AM
  5. How to display special characters XML
    By Cadallic in forum Windows Software
    Replies: 3
    Last Post: 07-08-2009, 12:49 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,823,622.67349 seconds with 16 queries