character set vs. collation
Taken from the docs:
"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 ä,ö,ü,ß?
"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
|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|