Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
5 registered members (Ruben, Basil, jbergmann, Geoff, Gizmo), 55 guests, and 393 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
JAISP
JAISP
Pennsylvania
Posts: 1,328
Joined: February 2007
Show All Member Profiles 
Top Posters(30 Days)
isaac 53
Gizmo 40
Geoff 32
Morgan 30
ECNet 17
Ruben 12
Mark S 11
JAISP 10
Bert 8
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
SQL : Collation Help #166476
10/18/06 07:34 PM
10/18/06 07:34 PM
Joined: Jul 2006
Posts: 4,715
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,715
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 07:43 PM
10/18/06 07:43 PM
Joined: Jun 2006
Posts: 16,830
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,830
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 08:01 PM
10/18/06 08:01 PM
Joined: Jul 2006
Posts: 4,715
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,715
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 08:22 PM
10/18/06 08:22 PM
Joined: Jun 2006
Posts: 16,830
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,830
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 08:22 PM
10/18/06 08:22 PM
Joined: Jun 2006
Posts: 16,830
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,830
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 08:30 PM
10/18/06 08:30 PM
Joined: Jul 2006
Posts: 4,715
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,715
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
Upgrading from 7.6.0 to 7.6.1
by Baldeagle. 01/20/18 01:07 PM
Odd behavior with marking forums as read
by Baldeagle. 01/20/18 12:51 PM
Subscription Pending Auto Update to Active
by Geoff. 01/18/18 09:04 AM
7.6.1.1 Custom Tag Editor (YouTube)
by Mark S. 01/15/18 02:58 PM
Enable Spider Friendly Urls Issues
by Geoff. 01/15/18 11:32 AM
Forum Statistics
Forums36
Topics35,049
Posts190,784
Members12,051
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1.1