Russian version
English version
| | | | SILICON TAIGA | ISDEF | CD | | | | | | | |
 
 
 
IT-
 
 
 
RSS-

. , :

  1. Upper Lower.
  2. (WIN1251), .. ......

, TRANSLATE. , PostgreSQL ( cygwin, ) :

CREATE FUNCTION "w_upper"("varchar") 
RETURNS "varchar" AS '
SELECT TRANSLATE($1, ''abcdefghijklmnopqrstuvwxyz'',
 ''ABCDEFGHIJKLMNOPQRSTUVWXYZ'')
' LANGUAGE 'sql';

CREATE FUNCTION "w_lower"("varchar") RETURNS "varchar" AS ' SELECT TRANSLATE($1, ''ABCDEFGHIJKLMNOPQRSTUVWXYZ'', ''abcdefghijklmnopqrstuvwxyz'') ' LANGUAGE 'sql';

, , Access' .

  1. , . , , . , .
  2. , , ORDER BY "" & MyTable.MyField. , .


     
 
 
  : 24.05.2006  

| | | | SILICON TAIGA | ISDEF | CD | | | | | | | |

: Silicon Taiga    
Rambler's Top100 Rambler's Top100