Re: Storing binary data (string with nulls/ASCII 0 in them) in CHAR/VARCHAR?

In the last episode (Nov 29), David Garamond said: > >It seems the string in CHAR/VARCHAR is stored as null-terminated ala > >C. But why is record 3 rejected too? > > Ugh, never mind. I forgot about the automatic trailing blanks removal > feature. Well, since trailing blan

Re: Storing binary data (string with nulls/ASCII 0 in them) in CHAR/VARCHAR?

|2 | 32 0 | ++--+--+ 4 rows in set (0.00 sec) It seems the string in CHAR/VARCHAR is stored as null-terminated ala C. But why is record 3 rejected too? Ugh, never mind. I forgot about the automatic trailing blanks removal feature. Well, since trailing blanks are always

Storing binary data (string with nulls/ASCII 0 in them) in CHAR/VARCHAR?

Can CHAR/VARCHAR store strings with nul (ASCII 0) in them? It seems it can't. [I've used CHAR(2), VARCHAR(2), CHAR(2) BINARY, VARCHAR(2) BINARY]. === create table t1 ( id int not null primary key, code varchar(2

RE: underline char in a [char][varchar][text] field ?

if your app is PHP, then use stripslashes() on field -Original Message- From: Pal Lucian [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: underline char in a [char][varchar][text] field ? Hello everybody, I have a problem inserting a

underline char in a [char][varchar][text] field ?

Hello everybody, I have a problem inserting a text from anywhere (application,console, doesn't matter) into a [char][varchar][text] field type. If I try to insert eg: 'hello_there.txt' in a field ot type I enlisted above ,when I read that field i get 'hello\_there.txt'

Re: char -> varchar ?

TECTED] a écrit : > Sujet :char -> varchar ? > Date :07/05/2001 23:42:12 Paris, Madrid (heure d'été) > From:[EMAIL PROTECTED] (Alec Solway) > To:[EMAIL PROTECTED] > > > > > Hi, > > In various create table statements char columns are converted to varcha

Re: char -> varchar ?

Alec Solway wrote: > > Hi, > > In various create table statements char columns are converted to varchar.. > I was wondering why this was happening. Here's an example: > > CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not > null, city VARCHAR(255) not null, state CHAR(2)

Re: char -> varchar ?

Types. - Original Message - From: "Alec Solway" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 07, 2001 2:38 PM Subject: char -> varchar ? > Hi, > > In various create table statements char columns are converted to varchar.. > I was wondering why this wa

char -> varchar ?

Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not nu

RE: Who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.

s not. > > --Matthew > > >>> "Nick Kostirya" <[EMAIL PROTECTED]> 01/26/01 11:42AM >>> > Hi. > > You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT. > I need to qu

Re: Who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.

.but in most cases not. --Matthew >>> "Nick Kostirya" <[EMAIL PROTECTED]> 01/26/01 11:42AM >>> Hi. You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT. I need to quicken DB to the maximum and to keep minimum size of the DB. Thanks. Nick.

Who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.

Hi. You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT. I need to quicken DB to the maximum and to keep minimum size of the DB. Thanks. Nick. - Before posting, please check: http://www.mysql.com/manual.php