#1  
Old 21st July 2005, 07:12 AM
Thomas Lohrum
 
Posts: n/a
Default character set vs. collation

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Application - UTF 8 - French character jprenou nexusdb.public.discussions 3 17th November 2010 11:36 PM
escape character to disable wildcard in LIKE Scott H nexusdb.public.discussions 1 1st October 2009 06:14 PM
Ordinal value of a character Gerard Hook nexusdb.public.support.sql 1 12th May 2008 01:44 PM
Access 97 - character scrambling Kris nexusdb.public.support.odbc 3 26th December 2003 10:42 AM
EM Beta 5 - Sorting bug with Chinese Character Mark Chang nexusdb.public.support 11 30th July 2003 12:50 AM


All times are GMT +11. The time now is 07:24 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.