Re: DATETIME vs CHAR for "timestamp"

> On Apr 14, 2017, at 1:07 PM, shawn l.green wrote: > > That all depends. Do you... Hi Shawn, I thought I had replied to your response, but it looks like I didn’t. Thank you for your email. It was a thorough response and the links were very helpful, as well. I’ve settled on both DA

Re: DATETIME vs CHAR for "timestamp"

On 4/14/2017 3:11 PM, SSC_perl wrote: I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19

DATETIME vs CHAR for "timestamp"

I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19)? Or would it not make a difference

Re: Storage of UTF-8 char in MySQL

Ryan,, all: Ryan Chan wrote: > According to this document: > http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html > > It said MySQL support UTF-8 using one to three bytes per character. > > But I have created a test table: > > -- create table test ( c char(5)

Re: Storage of UTF-8 char in MySQL

Ryan Chan wrote: > According to this document: > http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html > > It said MySQL support UTF-8 using one to three bytes per character. > > But I have created a test table: > > -- create table test ( c char(5) ) default char

Storage of UTF-8 char in MySQL

According to this document: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html It said MySQL support UTF-8 using one to three bytes per character. But I have created a test table: -- create table test ( c char(5) ) default charset =utf8; >From the table status, the data length

RE: How to specify CHAR column to accept specific characters

>-Original Message- >From: hezjing [mailto:hezj...@gmail.com] >Sent: Thursday, June 18, 2009 5:04 AM >To: mysql@lists.mysql.com >Subject: How to specify CHAR column to accept specific characters > >Hi >I'm using MySQL 5.1. > >How do we create a const

Re: How to specify CHAR column to accept specific characters

Hi, I'm using MySQL 5.1. How do we create a constraint on char column to accept only character 'A' - 'Z'? MySQL doesn't have CHECK constraints, I think the only way to do this is via a BEFORE INSERT trigger. With regards, Martijn Tonies Upscene Prod

How to specify CHAR column to accept specific characters

Hi I'm using MySQL 5.1. How do we create a constraint on char column to accept only character 'A' - 'Z'? Thank you! -- Hez

Re: MAC address as primary key - BIGINT or CHAR(12)

"I've run up on the rock of a binary (meaning: indecipherable) field." SELECT hex(some_binary_field) FROM table; Solved. The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of

RE: MAC address as primary key - BIGINT or CHAR(12)

A MAC address is just a number, it doesn't contain letters unless you're doing something silly like storing the HEX representation of it. Do not use CHAR! This does DOUBLE for all of you storing IP addresses! Since a MAC address is going to be between 48 and 64 bits, then

RE: MAC address as primary key - BIGINT or CHAR(12)

Store as CHAR(12), not VARCHAR because they are ALWAYS a fixed length. It saves space and is faster to index/lookup. If you're using IPv4 only then stick with CHAR(12). elseif you think you'll go to IPv6 then if large dataset (> 1M rows say), pl

Re: MAC address as primary key - BIGINT or CHAR(12)

I agree, and didn't mean to say that I disagreed. This is certainly one of the top five principles to follow, imo. Too many times, while trouble-shooting, I've run up on the rock of a binary (meaning: indecipherable) field. What is the cost of including the binary representation (for indexing)

Re: MAC address as primary key - BIGINT or CHAR(12)

er. > > I'll be interested in the answer, though, from someone with experience. > > -- Pete Wilson > http://www.pwilson.net/ > > > --- On Thu, 5/14/09, Jim Lyons wrote: > > > From: Jim Lyons > > Subject: Re: MAC address as primary key - BIGINT or CHAR(12) >

Re: MAC address as primary key - BIGINT or CHAR(12)

be interested in the answer, though, from someone with experience. -- Pete Wilson http://www.pwilson.net/ --- On Thu, 5/14/09, Jim Lyons wrote: > From: Jim Lyons > Subject: Re: MAC address as primary key - BIGINT or CHAR(12) > To: "Ilia KATZ" > Cc: mysql@lists.mysql.

Re: MAC address as primary key - BIGINT or CHAR(12)

Definitely CHAR (or VARCHAR). If the format of a MAC address changes at all, you could be in real trouble. Also, if a MAC address can have a leading 0 (I don't know anything about MAC addresses), then storing it as some sort of number could lose that. This is a general rule for me. A

Re: MAC address as primary key - BIGINT or CHAR(12)

On Thu, 14 May 2009, Ilia KATZ wrote: Hi. Currently I have a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changing it to CHAR(12)? Replies will be appreciated. Ilia Hi It depends. You may convert the MAC address to a decimal integer and store

RE: MAC address as primary key - BIGINT or CHAR(12)

6th byte the last 2 bytes (of the BIGINT) left unused. Ilia From: Fish Kungfu [mailto:fish.kun...@gmail.com] Sent: Thursday, May 14, 2009 3:54 PM To: Ilia KATZ Cc: mysql@lists.mysql.com Subject: Re: MAC address as primary key - BIGINT or CHAR(12

RE: MAC address as primary key - BIGINT or CHAR(12)

a problem. >-Original Message- >From: Ilia KATZ [mailto:ik...@dane-elec.co.il] >Sent: Thursday, May 14, 2009 9:26 AM >To: mysql@lists.mysql.com >Subject: MAC address as primary key - BIGINT or CHAR(12) > >Hi. >Currently I have a table: >1. MAC address defined as BIGI

Re: MAC address as primary key - BIGINT or CHAR(12)

On Thursday 14 May 2009 09:53:58 am Fish Kungfu wrote: > Since MAC addreses also contain letters, BIGINT wouldn't work. So, yes, I > would say go with CHAR(12). > > On May 14, 2009 9:43 AM, "Ilia KATZ" wrote: > > Hi. > Currently I have a table: > 1. MAC add

Re: MAC address as primary key - BIGINT or CHAR(12)

Since MAC addreses also contain letters, BIGINT wouldn't work. So, yes, I would say go with CHAR(12). On May 14, 2009 9:43 AM, "Ilia KATZ" wrote: Hi. Currently I have a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changin

MAC address as primary key - BIGINT or CHAR(12)

Hi. Currently I have a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changing it to CHAR(12)? Replies will be appreciated. Ilia

Re: Group by function and avg on char

roblem I'm trying to solve without success. Given the following table CREATE TABLE `scores` ( `proj` char(3) NOT NULL default '', `id` int(11) NOT NULL default '0', `score` double default NULL, `cpid` char(32) default NULL, `team` char(20) default NULL, PRIM

Group by function and avg on char

Hi all, got a simple problem I'm trying to solve without success. Given the following table CREATE TABLE `scores` ( `proj` char(3) NOT NULL default '', `id` int(11) NOT NULL default '0', `score` double default NULL, `cpid` char(32) default NULL, `team` char(20

Re: How to count # of occurrences of a char in a string?

At 04:52 PM 12/12/2007, Baron Schwartz wrote: Hi, On Dec 12, 2007 5:39 PM, mos <[EMAIL PROTECTED]> wrote: > I have a Char(50) column and I want to count the number of "." in the > column using a Select statement. I don't see any MySQL function that can > count

Re: How to count # of occurrences of a char in a string?

Hi, On Dec 12, 2007 5:39 PM, mos <[EMAIL PROTECTED]> wrote: > I have a Char(50) column and I want to count the number of "." in the > column using a Select statement. I don't see any MySQL function that can > count the number of occurrences of a character in a stri

How to count # of occurrences of a char in a string?

I have a Char(50) column and I want to count the number of "." in the column using a Select statement. I don't see any MySQL function that can count the number of occurrences of a character in a string. Is there a simple way to do this? TIA Mike -- MySQL General Mailin

RE: Query to find less than 3 char string

udes-marche.com > -Original Message- > From: Scott Mulder [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 20, 2007 2:21 PM > To: mysql@lists.mysql.com > Subject: Query to find less than 3 char string > > Just wondering if anyone out there may have a workaround

Query to find less than 3 char string

Just wondering if anyone out there may have a workaround to being stuck on a shared server with the default string matching set to more than 3 chars. I know that Navicat searches for 3 and under chars on my catalog when it's connected and that offered me some form of hope. On top of that I'm w

Re: Partial char key not used in conjuction with inequality comparison (MySQL5)

Hi Thomas, all! Thomas van Gulick wrote: [[...]] Test: EXPLAIN SELECT * FROM t WHERE T="x"; Result: key T used EXPLAIN SELECT * FROM t WHERE T!="x"; Result: key T _unused_ To be expected: An "unequal" condition will evaluate to "true" for a very large proportion of the index entries, so th

Partial char key not used in conjuction with inequality comparison (MySQL5)

Hello list! I've noticed in MySQL 5.0 partial keys on character fields aren't always used. In 4.1 they were. They seem not to be used when using inequality comparison. I'm not sure whether this is a bug or intended (in the latter case I have to work around it to get the speed I got with 4.1 ba

char vs. varchar

Hi all Which of these two tables wiil yield the best performance in a table with about 6 million entries (for rapid selects on either field): table_using_char field1 char(50), field2 char(50), filed 3 char(50), separate unique indexes on all 3 fields table_using_varchar field1 varchar(50

RE: Removing space characters ... char(160)? ... char(194)?

ormation Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Amer Neely [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 13, 2007 3:53 AM > To: mysql@lists.mysql.com > Subject: Re: Removing space character

Re: Removing space characters ... char(160)? ... char(194)?

Hi all. I'm trying to weed out garbage that comes from copying and pasting stuff from a web page. Some of the data has spaces, but a *different* kind of space ... a char(160) kind ... I think ... I figured this out by copying the space character and pasting it into mysql thus: s

Removing space characters ... char(160)? ... char(194)?

Hi all. I'm trying to weed out garbage that comes from copying and pasting stuff from a web page. Some of the data has spaces, but a *different* kind of space ... a char(160) kind ... I think ... I figured this out by copying the space character and pasting it into mysql thus: s

FW: varchar vs char - update statement

I have a database with several tables that can have up to 100 000 rows there is ~100 updates every seconds and ~100 select query on the same table using locks. The update is always on the same field a varchar(15), I believe it will be recommended to change it to char(15) to improve performance

varchar vs char - update statement

I have a database with several tables that can have up to 100 000 rows there is ~100 updates every seconds and ~100 select query on the same table with locks. The update is always on the same field a varchar(15), I believe it will be recommended to change it to char(15) to improve performance

Re: Counting char in a column

27;Mysql '" Sent: Tuesday, October 10, 2006 10:58 PM Subject: Counting char in a column I'm running MySQL 5.0.15 on Windows system. How do I count how many specific char is there in a column, for example finding 'c' in lowercase string of "Characteristics" wou

Counting char in a column

I'm running MySQL 5.0.15 on Windows system. How do I count how many specific char is there in a column, for example finding 'c' in lowercase string of "Characteristics" would total to 3. -- `Twa

Re: special char in full-text search

character programming language. Hope that gives you some ideas. - Original Message - From: "Harini Raghavan" <[EMAIL PROTECTED]> To: Sent: Thursday, July 06, 2006 2:06 AM Subject: special char in full-text search Hi All, I am using the MySQL full text search capabil

special char in full-text search

then it searches for M, B, and A sepearately. I can't include the quotes for all search strings as wild char(*) search would not work when specified within a phrase. Is there a way to avoid MySQL from tokenizing the search criteria? Any ideas? Thanks, Harini -- MySQL General Mailing Lis

char(17) vs. char(18)

Hi, Do you think there is any difference in the speed of select() statements done on a big table depending on whether one of the columns of this table is defined as char(17) or char(18)? That is, will the select speed depend on the parity of the number of chars? More generally, are char(2^n

RE: apostrophe char problem

> -Original Message- > From: Halid Faith [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 02, 2006 11:51 AM > To: mysql@lists.mysql.com > Subject: apostrophe char problem > > Hello > > I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and > apache-2

Re: apostrophe char problem

Something is double escaping the strings. Check if GPC magic string is enabled (apache's auto escaping). Also check if your code manually escapes the strings. Halid Faith wrote: Hello I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on FreeBSD5.3 I add any text as data wit

apostrophe char problem

Hello I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on FreeBSD5.3 I add any text as data with phpadmin on web. it works well. But I have a problem. As example if I add a text to mysql table with phpadmin. My text contains as below; "Halid 's car is expensive" I will see a

convert varchar/char to integer

Hi Gents Is it possible to sort char/varchars that only contains integers as integers and not as characters. I can't use integer because the standard says it may contain characters aswell. Currently I do this outside mysql in a perl-procedure. Whatever I try I get this

Re: convert varchar/char to integer

morten bjoernsvik <[EMAIL PROTECTED]> skrev: Hi Gents Is it possible to sort char/varchars that only contains integers as integers and not as characters. I can't use integer because the standard says it may contain characters aswell. Currently I do this outside mysql in a per

Re: CHAR vs TEXT and fast Row Updates

Hi, 2006/1/17, Karl Pielorz <[EMAIL PROTECTED]>: > > Hi All, > 1. Fixed length CHAR fields are quicker to update than VARCHAR fields > (because the field size is constant) There is no advantage if not all your field in your table are fixed size. as soon as you add a text/blob

CHAR vs TEXT and fast Row Updates

Hi All, We have an application that needs to update rows in the database 'as fast and efficiently' as possible. To this end, we've tried re-designing the table - can someone clarify the following assumptions we're about to make? 1. Fixed length CHAR fields are qu

CHAR() or NCHAR(1) in MySQL 5.0.18 for Wondows

Hello. MySQL 5.0.18 for Wondows. CREATE TABLE test (CHAR(1)). Not assigned 0x80 - 0xFF for CHAR(). When use: mysql_stmt_prepare(), mysql_stmt_bind_param(), mysql_stmt_execute(). For NCHAR() successfully assigned 0x80 - 0xFF. Successfully executed: INSERT INTO test (h) VALUES(CHAR(128

char() or nchar() in mysql 5.0.18

Hello. MySQL 5.0.18 Not assigned 0x80 - 0xFF for  CHAR(). When use: mysql_stmt_prepare(), mysql_stmt_bind_param(), mysql_stmt_execute(). For NCHAR() successfully assigned 0x00 - 0xFF. Successfully executed: INSERT INTO test (h) VALUES(CHAR(128

Re: IN(INT VS CHAR)

Hello. In my humble opinion, the design of the database should not depend on operators which you're going to use in your queries. Yes, using INTs in the IN clause (that means the the column type is INT as well, isn't it?) should be a bit faster, because operations with strings are in general

IN(INT VS CHAR)

When using IN should i design the database to use int's or is the performance equal? WHERE col IN('test','test2','test3') vs WHERE col IN(1,2,3) - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List Fo

Re: varchar vs char speed improvement

On Tuesday 27 September 2005 11:59, Pooly wrote: > 2005/9/27, Ow Mun Heng <[EMAIL PROTECTED]>: > > Is there any doc looking at benchmarks of a database which is populated > > entirely with fixed length char compared to variable character lengths? > > > > I know usi

Re: varchar vs char speed improvement

2005/9/27, Ow Mun Heng <[EMAIL PROTECTED]>: > Is there any doc looking at benchmarks of a database which is populated > entirely with fixed length char compared to variable character lengths? > > I know using char is preferred over varchar when it comes to speed. Is >

varchar vs char speed improvement

Is there any doc looking at benchmarks of a database which is populated entirely with fixed length char compared to variable character lengths? I know using char is preferred over varchar when it comes to speed. Is there any available benchmarks available? Pointers where would be appreciated

Re: convert varchar to char

Pooly wrote: Damnit ! Thanks for pointing it, I forgot these things. But it's a bit more subtle : If any column in a table has a variable length, the entire row becomes variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all

Re: convert varchar to char

for pointing it, I forgot these things. > > But it's a bit more subtle : > > [snip] > > Bah, should have waited another 5 minutes before I bothered posting my > last long-winded ramble ;) > > > ALTER TABLE sessions MODIFY id char(32) NOT NULL DEFAULT '', M

Re: convert varchar to char

On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > Damnit ! > Thanks for pointing it, I forgot these things. > But it's a bit more subtle : [snip] Bah, should have waited another 5 minutes before I bothered posting my last long-winded ramble ;) > ALTER TABLE sessions

Re: convert varchar to char

On Sat, Aug 13, 2005 at 04:01:38PM +0100, Pooly wrote: > > ALTER TABLE sessions MODIFY ip char(8) NOT NULL DEFAULT '0'; > ALTER TABLE sessions MODIFY id char(32) NOT NULL DEFAULT ''; Hello, Since you have two varchar columns, I don't think there's any w

Re: convert varchar to char

Damnit ! Thanks for pointing it, I forgot these things. But it's a bit more subtle : If any column in a table has a variable length, the entire row becomes variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns l

Re: convert varchar to char

Pooly wrote: Hi, I try to convert a varchar to a char, but it doesn't seems to work. From the manual: "...all CHAR columns longer than three characters are changed to VARCHAR columns." http://dev.mysql.com/doc/mysql/en/silent-column-changes.html > -- Roger -- MySQL Ge

convert varchar to char

Hi, I try to convert a varchar to a char, but it doesn't seems to work. show create table sessions; CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL default '', `user_id` int(6) NOT NULL default '0', `ip` varchar(8) NOT NULL default '0', `l

Re: default collation char

Philippe Poelvoorde wrote: Enrique Sanchez Vela wrote: I would like to have MySQL differentiate between 'abc' and 'ABC' both the server and clients. so far anything I've done has not worked. Is altering the column type an option ? If yes, you would change any 'text' for 'blob' and any 'varcha

Re: default collation char

Enrique Sanchez Vela wrote: Hello Folks, I would like to have MySQL differentiate between 'abc' and 'ABC' both the server and clients. so far anything I've done has not worked. Is altering the column type an option ? If yes, you would change any 'text' for 'blob' and any 'varchar' for 'varcha

default collation char

Hello Folks, I would like to have MySQL differentiate between 'abc' and 'ABC' both the server and clients. so far anything I've done has not worked. when I defined the database it was using the latin1_swedish_ci Collation, now I have issued the alter database COLLATE to use latin1_bin one, droped

Re: char(x) showing up as varchar(x)...

thanks. - philip On May 28, 2005, at 10:08 PM, Paul DuBois wrote: http://dev.mysql.com/doc/mysql/en/silent-column-changes.html At 21:29 -0500 5/28/05, Philip George wrote: when i create a table with: CREATE TABLE person ( id char(36) NOT NULL PRIMARY KEY, firstname varchar(50

Re: char(x) showing up as varchar(x)...

http://dev.mysql.com/doc/mysql/en/silent-column-changes.html At 21:29 -0500 5/28/05, Philip George wrote: when i create a table with: CREATE TABLE person ( id char(36) NOT NULL PRIMARY KEY, firstname varchar(50) DEFAULT NULL, lastname varchar(50) DEFAULT NULL ); ...and then use

char(x) showing up as varchar(x)...

when i create a table with: CREATE TABLE person ( id char(36) NOT NULL PRIMARY KEY, firstname varchar(50) DEFAULT NULL, lastname varchar(50) DEFAULT NULL ); ...and then use describe to show what i've got: mysql> describ

char field length get 2 times in GB2312

Hi, After SET CHARACTER SET GB2312 , create table a1 (b1 char(6)) charset=gb2312, the char field width in 2 times. select * from a1 胶版材料重量 123456 金属材料12 Should be 胶版材 123456 金属材 server : win98/linux mysql4.1.11 client : windows ,bcc55,libmysql.dll

Re: field varchar and char truncate the ended blank characters

Hello, > Using TEXT or BLOB prevent me to display the string in a dbgrid, the real > data is replaced by a text like "(MEMO)". > I can use somethinh like "select substring( msg, 1,100 ) from mytable " to > bypass the problem but is no the clean solution I looking for. > I thank for your hints but

R: field varchar and char truncate the ended blank characters

but I'm looking, if possible, for a different solution. Other ideas ? -Messaggio originale- Da: Gleb Paharenko [mailto:[EMAIL PROTECTED] Inviato: lunedì 28 febbraio 2005 14.41 A: mysql@lists.mysql.com Oggetto: Re: field varchar and char truncate the ended blank characters Hello.

Re: field varchar and char truncate the ended blank characters

uot; middle ", when I read thei > field I get "abc" and " middle". > > create table pippo ( codice int, messaggio varchar(20), a char(20)); > > insert into pippo values( 1, "abc ", "123 " ); > insert into pippo values(

field varchar and char truncate the ended blank characters

example if I have a table like the one belowe and insert some field with blank characters at the end , like "abc " or " middle ", when I read thei field I get "abc" and " middle". create table pippo ( codice int, messaggio varchar(20), a char(20)); i

Re: Is this by design - compare CHAR BINARY with CHAR

Hello. Use CAST(). See: http://dev.mysql.com/doc/mysql/en/Charset-CAST.html Jens Schreiber <[EMAIL PROTECTED]> wrote: > Hello, > > I'm using 4.1.8-standard on linux and get this: > > CREATE TABLE test (field1 CHAR(20) BINARY NOT NULL, field2 CHAR(20

Is this by design - compare CHAR BINARY with CHAR

Hello, I'm using 4.1.8-standard on linux and get this: CREATE TABLE test (field1 CHAR(20) BINARY NOT NULL, field2 CHAR(20) NOT NULL) TYPE=MyISAM; INSERT INTO test VALUES('xxx','yyy') SELECT * FROM test WHERE field1=field2 ERROR 1267 (HY000): Illegal mix of collations

Re: Char to Varchar on Innodb

Gary, - Alkuperäinen viesti - Lähettäjä: "Gary Richardson" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Thursday, October 21, 2004 4:49 AM Aihe: Re: Char to Varchar on Innodb > I

Re: Char to Varchar on Innodb

e, wouldn't all the CHAR fields need to be left-packed? For example, you'd still get fragmentation if your columns went CHAR, VARCHAR, CHAR. I guess that is unless the engine underneath did this automagically. Thanks. On Wed, 20 Oct 2004 11:29:30 +0300, Heikki Tuuri <[EMAIL PROTECTED

Re: Char to Varchar on Innodb

Hello, > those 'silent column specification changes' affect all table types. That > feature has caused lots of user questions over years. It is in the TODO to > remove that feature from MySQL, because it is not standards compliant. In > InnoDB, a reason to use a CHAR colu

Re: Char to Varchar on Innodb

Gary, those 'silent column specification changes' affect all table types. That feature has caused lots of user questions over years. It is in the TODO to remove that feature from MySQL, because it is not standards compliant. In InnoDB, a reason to use a CHAR column in some cases is

Char to Varchar on Innodb

Hey, >From http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html: If any column in a table has a variable length, the entire row becomes variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than th

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

> > > > I have a questions about "varchar columns" change to "CHAR columns" > > > > automatically. > > > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html > > > In addition to that - it doesn't really matter as

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

On Mon, 23 Aug 2004 15:25:21 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > I have a questions about "varchar columns" change to "CHAR columns" > > > automatically. > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html &

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

> > I have a questions about "varchar columns" change to "CHAR columns" > > automatically. > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html In addition to that - it doesn't really matter as the CHAR datatype isn't properly

Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

Emi Lu <[EMAIL PROTECTED]> wrote: > I have a questions about "varchar columns" change to "CHAR columns" > automatically. See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html -- For technical support contracts, goto https://order.mysql.com/?ref=e

RE: Why "VARCHAR" TO "CHAR" automatically when the length less th an 4.

This is described here: http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html. The table is created as a fixed table format. -Original Message- From: Emi Lu To: [EMAIL PROTECTED] Sent: 8/16/04 3:20 PM Subject: Why "VARCHAR" TO "CHAR" automatically when th

Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

Hello all, I have a questions about "varchar columns" change to "CHAR columns" automatically. When I designed a table t1 create table t1(id varchar(3) not null) in MySQL. After that, we use "desc t1" to see the description of table &quo

Using foreign char sets

Hi, My native tongue is english but I'm learning finnish and want to create a database using my new language. Swe7 will apparently cover the few characters I need which aren't part of the latin1 set. So I've restarted the server with the option, --default-character-set=swe7 What I think I need n

Re: storing international char, like (Arabic, Russian) on mysql

thank you very much On Tue, 3 Aug 2004 20:08:51 -0500 (CDT), [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, > > I have made apresentation at MySQLs UC2004 about using Japanese character > sets with MySQL. You may find this a good starting point. Links are below: > > http://dev.mysql.com/d

storing international char, like (Arabic, Russian) on mysql

Is it possible to store foreign language characters like arabic, russian, etc on mysql? when a user send out data via the web? where should i start? -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: all upper case records.. Keeping first char upper and rest lower?

or me to do a select statement that makes all chars after the first char lower case? Example: Current: AARON After: Aaron I think this is possible.. just don't know how to execute the functions together to make it happen. Thanks! Aaron -- MySQL General Mailing List For list archives: http:/

RE: all upper case records.. Keeping first char upper and rest lower?

ginal Message- > From: Wesley Furgiuele [mailto:[EMAIL PROTECTED] > Sent: July 13, 2004 1:10 PM > To: Aaron Wolski > Cc: [EMAIL PROTECTED] > Subject: Re: all upper case records.. Keeping first char upper and rest > lower? > > > SELECT CONCAT( UPPER( LEFT( first, 1 ) )

Re: all upper case records.. Keeping first char upper and rest lower?

o a select statement that makes all chars after the first char lower case? Example: Current: AARON After: Aaron I think this is possible.. just don't know how to execute the functions together to make it happen. Thanks! Aaron -- -- MySQL General Mailing List For list archives: http://lists.mys

all upper case records.. Keeping first char upper and rest lower?

Hey guys, I have a column in a table called 'first'. Currently all records are upper case. Is it possible for me to do a select statement that makes all chars after the first char lower case? Example: Current: AARON After: Aaron I think this is possible.. just don't know how

Re: Datatype question - Whether int(11) or char(11) ?

On Monday 05 July 2004 12:54 pm, Ying Lu wrote: > Hello all, > > I have a datatype question. > > When there is column named ID, users are able to > give it either char(11) or int(11). > > Please advise, which type is better such as more > secure, save space, etc? Or

Datatype question - Whether int(11) or char(11) ?

Hello all, I have a datatype question. When there is column named ID, users are able to give it either char(11) or int(11). Please advise, which type is better such as more secure, save space, etc? Or it dose not matter at all? Kind regards, Ying -- MySQL General Mailing List For list archives

Re: making lower case then first char to upper case?

On Wed, 30 Jun 2004, Aaron Wolski wrote: > Hi Guys, > > I'm trying to figure out of this is possible. I know I could do it in > PHP but I am dealing with a ton of records and would rather put the > processing on the DB than PHP/client side. > > Question is. can I do a SELECT query on a column that

AW: making lower case then first char to upper case?

ndet: Mittwoch, 30. Juni 2004 18:46 > An: [EMAIL PROTECTED] > Betreff: making lower case then first char to upper case? > > Hi Guys, > > I'm trying to figure out of this is possible. I know I could > do it in PHP but I am dealing with a ton of records and would > r

Re: making lower case then first char to upper case?

Someone else hopefully has something more efficient: UPDATE table SET field = CONCAT( UPPER( LEFT( field, 1 ) ), LOWER( SUBSTRING( field, 2 ) ) ) Wes On Jun 30, 2004, at 12:46 PM, Aaron Wolski wrote: Hi Guys, I'm trying to figure out of this is possible. I know I could do it in PHP but I am deali

making lower case then first char to upper case?

Hi Guys, I'm trying to figure out of this is possible. I know I could do it in PHP but I am dealing with a ton of records and would rather put the processing on the DB than PHP/client side. Question is. can I do a SELECT query on a column that changes all the results to lower case and THEN chan

  1   2   3   4   >