|
Log in |
FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() Taken from the docs:
CHARACTER SETs -------------- "CHARACTER SET and CODEPAGE are used interchangeably to specify the encoding used by the character string type." Does this relate to the storing of char data? For example german chars ä,ö,ü,ß? COLLATIONs ---------- "COLLATE and LOCALE are used interchangeably to specify an explicit collation for the character string and national character string types. " Does this relate to retrieving of char data, respecitvely when comparing chars, e.g. WHERE charcolumn = <string-literal>? Do i have to define both CHARACTER SETs and COLLATIONs when creating a table? Thank you, Thomas. |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Web Application - UTF 8 - French character | jprenou | nexusdb.public.discussions | 3 | 18th November 2010 12:36 AM |
escape character to disable wildcard in LIKE | Scott H | nexusdb.public.discussions | 1 | 1st October 2009 07:14 PM |
Ordinal value of a character | Gerard Hook | nexusdb.public.support.sql | 1 | 12th May 2008 02:44 PM |
Access 97 - character scrambling | Kris | nexusdb.public.support.odbc | 3 | 26th December 2003 11:42 AM |
EM Beta 5 - Sorting bug with Chinese Character | Mark Chang | nexusdb.public.support | 11 | 30th July 2003 01:50 AM |