Table field for 00101010 value

[SatuPortal_com]

Can anyone help me for my problem. I am new in MySQL.
I want to create a field on clients table with this :

id int(8) zerofill not null,

but when i use this field on my php script and fill in the 00101010 value, it shows 00000000 not 00101010

So what the type of the field i must use if i want to fill in the field numbers that have 00 value at front (e.g. 0010101010)

I also tried : id varchar(8) not null,

but the result was 101010 not 00101010 😕

i already tried to change the type to char but it only save for 1 character only. If I change to 10 character :

id char(10) not null,

the result become : id varchar(10) not null, on mySQL

I need to get the 'id' works for number like 00101010 because i use 00 at front as year 2000 identity

Thanks

[Bunkermaster]

you can't store binary data in an int, it'll trim the leading 0s

create a char( 8 ) field and have a go at it

[SatuPortal_com]

Thanks Bunkermaster .

Now, i have another question, how to avoid the same number will be using for other id's ?

What command i must add to my php script ?

[Bunkermaster]

make your field primary key and check for existance in your table before inserting, one thing though, there are only 256 combinations on a 8 bit binary value

[SatuPortal_com]

this field is on second field and the primary is for session id.

how to check the existance in my table ?

[Bunkermaster]

query? 😉

[[deleted]]

"make your field primary key and check for existance in your table before inserting, "

That won't do in a multi-user environment unless you lock the entire table before you check it.

Instead, put a UNIQUE index on the column and just insert the data. If the value already existed, the insert will fail and return an error mentioning the offending column in mysql_error().

[Bunkermaster]

^ he's right (never read anything from me posted on a saturday night after 9 PM, really)

😃