|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
December 22nd, 2006, 08:05 AM
|
|||
|
|||
|
SQL Beginner Question
I“ve just started working with Firebird databases and I would like to update a column (text value field) with uppercase characters (e.g. John -> JOHN). The problem is that spanish accents are not updated. Using the UPPER function Marķa turns MARķA. Is there a replace function or similar to change ķ for I? Where can I get some info about statements and functions for Firebird?.
Thanks in advance for your help and Happy Holidays.
|
|
#2
December 22nd, 2006, 08:10 AM
|
||||
|
||||
|
Look at the sticky thread on top of this forum for resources.
Note that I is uppercase for i and not for ķ
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > SQL Beginner Question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
