MySQL Question

jackpod · 09-21-2006, 03:21 PM

When I installed PhpDig, the tables were created with a collation of latin1_swedish_ci.

Is this a problem? And if so, what should I tell my ISP, specifically, so they can adjust this on the server?

Dave A · 09-21-2006, 09:30 PM

The swedish language is based on latin (as is evidenced by the name latin_swedish) and uses all of our standard characters as well as a few extras. Thing is, you might get some unexpected results in searches that you do because the swedish language includes extra characters or does not include some characters that you think should or should not be there. Things like alter table commands could behave in unexpected ways...even though it would be doing it correctly by the Swedish language, it may not be correct for English. Make sense?

09-21-2006, 03:21 PM	#1
jackpod Green Mole Join Date: Sep 2006 Posts: 4	MySQL Question When I installed PhpDig, the tables were created with a collation of latin1_swedish_ci. Is this a problem? And if so, what should I tell my ISP, specifically, so they can adjust this on the server?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
question about the installation	west	Script Installation	1	02-01-2005 11:52 AM
Yet Another indexing question	ffe	Troubleshooting	4	01-23-2005 08:16 AM
phpnuke 7.5 question	chris44gw	Coding & Tutorials	2	12-09-2004 11:36 AM
Another URL Question please.	Kenny	How-to Forum	2	12-01-2004 06:17 AM
A newbie question	z_newbie	Coding & Tutorials	2	06-14-2004 11:55 AM

09-21-2006, 09:30 PM	#2
Dave A Purple Mole Join Date: Aug 2004 Location: North Island New Zealand Posts: 170	The swedish language is based on latin (as is evidenced by the name latin_swedish) and uses all of our standard characters as well as a few extras. Thing is, you might get some unexpected results in searches that you do because the swedish language includes extra characters or does not include some characters that you think should or should not be there. Things like alter table commands could behave in unexpected ways...even though it would be doing it correctly by the Swedish language, it may not be correct for English. Make sense?