AardvarkBusiness.net - Business Search Engine AardvarkBusiness.net - Business Search Engine



 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

     

MySQL question: Collation set automatically ???

 
 
Post new topic   Reply to topic    AardvarkBusiness.net Forum Index -> Programming Forum
View previous topic :: View next topic  
Author Message
foundThroughAdminSig
President
President


Joined: 24 Apr 2004
Posts: 6491

7611 ants

PostPosted: Tue Nov 13, 2007 9:36 am    Post subject: MySQL question: Collation set automatically ??? Reply with quote

I archived a database stored in MySQL 3.23.x (on my server) and extracted it locally; Im running MySQL 4.1.x locally. It seems that Collation was set automatically to latin1_swedish_ci.

q1. Is this operation supposed to set Collation automatically???

q2. If so, why is it set to latin1_swedish_ci???
_________________
Online Education :: Training Forum
Chat about health ... Finance Books
Back to top
View user's profile Send private message Visit poster's website
trev
President
President


Joined: 15 Oct 2002
Posts: 3011
Location: NW England, UK
4037 ants

PostPosted: Sat Nov 24, 2007 12:34 am    Post subject: Reply with quote

I don't think prior to 4.1 you could set this on a per row basis so it automatically does it for you. As for "latin1_swedish_ci", that's apparently std. latin, but with a few extras for most Euro languages and is first on the list - from memory reading on MySQL.

Basically it'll work perfectly well for all Euro languages and includes all the accents and such.

Trev
_________________
Mad Theories - Ambleside - Coniston - Grange
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    AardvarkBusiness.net Forum Index -> Programming Forum All times are GMT + 1 Hour
Page 1 of 1

 
Google
 
Business Forum Sport Forum Travel Forum


Powered by php B B © 2001, 2002 php B B Group

AardvarkBusiness.net Business Search Engine & Directory