Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (Ruben, Gizmo), 77 guests, and 209 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 572
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Ruben 29
Gizmo 27
isaac 24
fuzzy47 24
Morgan 12
Basil 5
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
SQL : Collation Help #166476
10/18/06 08:34 PM
10/18/06 08:34 PM
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
I'm sure ive seen a update sql for this somewhere.

But anyway,
after my import classic to threads,
ive noticed that the Collation is set to latin1_swedish_ci

Does some one have a query i can run to update the 51
tables i now have. As they are all latin1_swedish_ci

What should they be set too?
I'm english and in the uk smile
Not my fault lol...

And i could also ask could this cause any problems
with the database. running under latin1_swedish_ci

Thanks in advacne for any help

Mark.


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: SQL : Collation Help [Re: Mark S] #166477
10/18/06 08:43 PM
10/18/06 08:43 PM
Joined: Jun 2006
Posts: 16,903
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,903
Portland, OR; USA
I believe latin1_swedish_ci is the default latin-based character set; it should be this imo, it's what all of my db's are set to and running without issue...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL : Collation Help [Re: Gizmo] #166479
10/18/06 09:01 PM
10/18/06 09:01 PM
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
I'm sure i seen UF8 or somthing like that?


But as long as it wont cause any issues that cool.

I cant spell latin or swedish words lol...

1 swedish word i know sauna lol


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: SQL : Collation Help [Re: Mark S] #166481
10/18/06 09:22 PM
10/18/06 09:22 PM
Joined: Jun 2006
Posts: 16,903
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,903
Portland, OR; USA
well if you think about it, sweedish words utilize accents (letters with the symbols above them) and most written languages are based off of latin letters; so it would lead to say that its only for what is allowed....

But we'll wait on rick for the 411 wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL : Collation Help [Re: Gizmo] #166482
10/18/06 09:22 PM
10/18/06 09:22 PM
Joined: Jun 2006
Posts: 16,903
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,903
Portland, OR; USA
Sauna is a sweedish word? laugh


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL : Collation Help [Re: Gizmo] #166483
10/18/06 09:30 PM
10/18/06 09:30 PM
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
its either that or IKEA frown


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Backgroud colors in posts
by fuzzy47. 04/16/18 08:27 PM
Avatar Upload Issue
by fuzzy47. 04/15/18 11:58 AM
Forum database - Table prefix question
by Morgan. 04/15/18 06:45 AM
Old Forum Archives
by TGCsanderson. 04/13/18 06:05 PM
Gallery
by fuzzy47. 04/12/18 09:48 AM
Forum Statistics
Forums36
Topics35,104
Posts191,183
Members12,068
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180410)