Re: [PHP] truncate a mb-string to a given octet length?
[email protected] (Tom Worster)
| Newsgroups | php.general |
|---|---|
| Message-ID | <C6580703.D2CB%[email protected]> |
On 6/12/09 11:52 AM, "Eddie Drapkin" <[email protected]> wrote: > Correct me if I'm wrong, but should varchar 255 with a utf8 character set mean > 255 unicode characters, not octets? in mysql, the length refers to the storage space of the string, not the decoded character count. i don't know about other dbms. > On Fri, Jun 12, 2009 at 11:50 AM, Tom Worster <[email protected]> wrote: > say a table in the db has a varchar(255) column, 255 being the max number of >> octets of strings that can go in the column. now say the php script very >> occasionally has to deal with utf8 input strings with octet length > 255 -- >> it needs to select rows matching the input string or insert the input >> string. >> >> so what i think i need is a function to truncate a utf8 string to the >> longest valid utf8 string that has octet length <= 255. >> >> is this what mb_strcut() is for? i'm having a hard time understanding the >> man page for that function.