Re: My Unicode Woes - Plz Help!!!

2004-04-23 Thread Stormblade
vice that holds the UTF-8 or UCS data. What is NAS? I have heard of people using Blobs to store unicode but I have no idea how to do this. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Pro

My Unicode Woes - Plz Help!!!

2004-04-22 Thread Stormblade
transparent to my client who enters this data from a web form usually copy and paste from Word. Thanks in advance for any help. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+

MySQL 4.0 and Unicode

2004-04-21 Thread Stormblade
s involved working with 4.0. Also foreign keys. Do the innob tables of 4.0 support foreign keys? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysyst

Re: Problem retrieving Unicode data

2004-04-21 Thread Stormblade
for my own personal use but for this current project I think I need to wait for releases. Thanks much for you help. I guess before I go any further I need to update the database to see if the problems I'm having right now are fixed or not in the latest versions. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: Problem retrieving Unicode data

2004-04-21 Thread Stormblade
On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote: > Stormblade, > > If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_ > charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a > property to your JDBC connection st

Re: Problem retrieving Unicode data

2004-04-20 Thread Stormblade
ySQL JDBC driver. Any help would be most appreciated. On Tue, 20 Apr 2004 18:59:51 -0500, Paul DuBois wrote: > At 19:49 -0400 4/20/04, Stormblade wrote: >>After reading a bit it seems my problem stems from the fact that although >>my database and tables are all utf8 the "con

Re: Problem retrieving Unicode data

2004-04-20 Thread Stormblade
must be part of the connection string. Thanks for the reply. On Tue, 20 Apr 2004 18:59:51 -0500, Paul DuBois wrote: > At 19:49 -0400 4/20/04, Stormblade wrote: >>After reading a bit it seems my problem stems from the fact that although >>my database and tables are all utf8 the "

Problem retrieving Unicode data

2004-04-20 Thread Stormblade
ns a connection? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailin

RE: Gripe with MySQL

2004-04-20 Thread Stormblade
see how things go. According to some they are already adding features that will make MySQL more flexible so that those who don't need/want the server side checks can happily not have them and those who do can. -- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years P

RE: Gripe with MySQL

2004-04-20 Thread Stormblade
--- Original Message --- From: "Stormblade" <[EMAIL PROTECTED]> To: Donny Simonton <[EMAIL PROTECTED]> Cc: Sent: Tue, 20 Apr 2004 12:59:58 -0400 Subject: RE: Gripe with MySQL > On Tue, 20 Apr 2004 11:37:12 -0500, Donny Simonton wrote: > Everybody should remembe

Re: MySQL and Unicode

2004-04-20 Thread Stormblade
located in the windows directory. I copy and pasted the line you gave here and put it under the [mysqld] section in that ini file. Yes I restarted the server. > > >> Here's my variables: >> >> >> character_set_server: latin1 >> character_set_system: utf8 >> c

Re: MySQL and Unicode

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 12:13:07 -0500, Paul DuBois wrote: > At 13:03 -0400 4/20/04, Stormblade wrote: >> On Tue, 20 Apr 2004 11:49:46 -0500, Paul DuBois wrote: >>>>> Make sure the server really is picking up the option value: >>>>> >>>>> >>

Re: MySQL and Unicode (Solved)

2004-04-20 Thread Stormblade
reate the tables (There's only 2) that will contain unicode data. Anyway, thanks for the help. I'm gonna go eat now. -- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) "The worth of your opinion is in direct proportion to the number of people w

RE: Gripe with MySQL

2004-04-20 Thread Stormblade
not just one global error checking type. > > Thanks, > > > Mike > > >> -Original Message- >> From: Donny Simonton [mailto:[EMAIL PROTECTED] >> Sent: 20 April 2004 17:37 >> To: 'Michael McTernan'; 'Stormblade' >> Cc: [EMAIL PROTECTE

Re: Gripe with MySQL

2004-04-20 Thread Stormblade
n my main gripe with it would be null and void and then I could recommend it for the situations I mentioned. But not any of the current versions. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming ex

Re: MySQL and Unicode

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 11:32:22 +0300, Victoria Reznichenko wrote: > Stormblade <[EMAIL PROTECTED]> wrote: >> Hopefully this will be the last snag...least till the next one :) >> >> I'm having a problem setting the charset to unicode (utf-8). If I >> understo

Re: Gripe with MySQL

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 09:48:11 +0200 (CEST), Jochem van Dieten wrote: > Stormblade said: >> Ok. Love MySQL and I will be using it for my personal use and >> recommending it to clients as a lower cost alternative. I've only >> been using it for a very short time but th

MySQL and Unicode

2004-04-19 Thread Stormblade
e? If so how? In any case, I need to be able to store unicode data and retrieve it. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid

Re: Gripe with MySQL

2004-04-19 Thread Stormblade
On Mon, 19 Apr 2004 20:17:38 -0700 (PDT), Marc Slemko wrote: > On Mon, 19 Apr 2004, Stormblade wrote: > >> Ok. Love MySQL and I will be using it for my personal use and recommending >> it to clients as a lower cost alternative. I've only been using it for a >> very s

Gripe with MySQL

2004-04-19 Thread Stormblade
database integrity is a bad idea in my experience. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- --

Re: Datetime Default Value

2004-04-19 Thread Stormblade
hat it can store the same range of dates as datetime? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandte

Re: Datetime Default Value

2004-04-19 Thread Stormblade
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote: > At 13:30 -0400 4/18/04, Stormblade wrote: >>On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote: >> >>> Stormblade wrote: >>> >>>> Hey all, >>>> >>>> I

Re: varchar < 4 = char < 4? Why?

2004-04-18 Thread Stormblade
/doc/mysql/en/Silent_column_changes.html> section of > the manual. > > Michael -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: Datetime Default Value

2004-04-18 Thread Stormblade
On Sun, 18 Apr 2004 14:42:51 -0400, Michael Stassen wrote: > Stormblade wrote: > >> On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote: > Functions are evaluated by the server. The client only sends queries and > receives results. So, CURDATE() and NOW() are serve

Re: Datetime Default Value

2004-04-18 Thread Stormblade
On Sun, 18 Apr 2004 13:54:22 -0400, Rhino wrote: > Stormblade (and anyone watching this thread), > > Just watch yourself when deciding between DATETIME and TIMESTAMP; the two > datatypes support very different ranges of values! Thanks for the heads up! > > According to th

varchar < 4 = char < 4? Why?

2004-04-18 Thread Stormblade
know. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Ma

Re: Datetime Default Value

2004-04-18 Thread Stormblade
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote: > Stormblade wrote: > >> Hey all, >> >> I'm currently converting a SQLServer 2000 database over to MySQL. I have a >> web application that currently uses SQLServer but will be using MySQL soon >

Re: Datetime Default Value - I want to know too!

2004-04-18 Thread Stormblade
now > if a default can be set. > > Regards, > Adam -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.

Datetime Default Value

2004-04-17 Thread Stormblade
er way if one exists. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailing Li