Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 27-10-2008
Member
 
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?
Reply With Quote
  #2  
Old 27-10-2008
Member
 
Join Date: Oct 2008
Posts: 29
Re: SQL - bp insert special characters with UPPER

is not a problem of encoding?
Reply With Quote
  #3  
Old 27-10-2008
Member
 
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 ...
Reply With Quote
  #4  
Old 27-10-2008
Member
 
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;
Reply With Quote
  #5  
Old 27-10-2008
Member
 
Join Date: Oct 2008
Posts: 89
Re: SQL - bp insert special characters with UPPER

Good point, I will test it and see
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL - bp insert special characters with UPPER"
Thread Thread Starter Forum Replies Last Post
Special Characters in SMS turn them shorter (70 characters instead of 160 characters) Xymaya Portable Devices 5 23-12-2010 07:12 PM
How to insert special characters online forms in Mozilla Firefox? Zhankana_n Technology & Internet 5 05-03-2010 09:01 PM
Not able to insert special characters in MAC Adonis Windows Software 5 16-02-2010 01:06 PM
How to Insert Special Characters in JavaScript? super soaker Software Development 4 02-02-2010 05:16 AM
How to display special characters XML Cadallic Windows Software 3 07-08-2009 12:49 PM


All times are GMT +5.5. The time now is 09:40 PM.