On 3/2/2016 11:29 AM, McGranahan, Jamen wrote:
Have two virtual machines, both running RedHat 7. Both are also running MySQL
5.6.29 and both have the same data. We have two databases, however, that keep
throwing odd characters on one system but it's OK on the other and we've not
ml>.
On Wed, Mar 2, 2016 at 11:29 AM, McGranahan, Jamen <
jamen.mcgrana...@vanderbilt.edu> wrote:
> Have two virtual machines, both running RedHat 7. Both are also running
> MySQL 5.6.29 and both have the same data. We have two databases, however,
> that keep throwing odd characters
McGranaham, Jamen wrote:
Have two virtual machines, both running RedHat 7. Both are also running
MySQL 5.6.29 and both have the same data. We have two databases, however,
that keep throwing odd characters on one system but it's OK on the other and
we've not been able to figure out why
Have two virtual machines, both running RedHat 7. Both are also running MySQL
5.6.29 and both have the same data. We have two databases, however, that keep
throwing odd characters on one system but it's OK on the other and we've not
been able to figure out why.
What it should look
On 09/27/2013 12:48 AM, Anders Karlsson wrote:
Try specifying the utf8_bin collation instead and that will work.
or if you need comparisons to be case insensitive, but still want
to have accented letters be considered different to their base
form and to each other you may want to have a look h
son
Daevid Vincent skrev 2013-09-26 23:44:
How come MySQL is not differentiating between these characters?
SELECT text_id, us, de, es, fr
FROM texts
WHERE us = fr;
Results in matching here. Notice the difference in the "scene" vs "scène"
text_id
Hi,
> I wold expect this NOT to match.
This should be because the fields you are comparing are utf8_general_ci,
this collation groups characters in 'classes' so that all variants of what
are considered to belong to the same character type, are put in that class.
Equality compa
How come MySQL is not differentiating between these characters?
SELECT text_id, us, de, es, fr
FROM texts
WHERE us = fr;
Results in matching here. Notice the difference in the "scene" vs "scène"
text_id us e
; What are you using to view the data?
>>>
>>> On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote:
>>>> ;>>> 2011/11/20 20:27 +, Tompkins Neil >>>>
>>>> Does anyone know why Chinese characters are not displaying correctly
>&
Neil Tompkins wrote:
> MySQL workbench
>
> On 21 Nov 2011, at 13:36, Chris Tate-Davies
wrote:
> > What are you using to view the data?
> >
> > On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote:
> >> ;>>> 2011/11/20 20:27 +, Tompkins Neil >
MySQL workbench
On 21 Nov 2011, at 13:36, Chris Tate-Davies
wrote:
> What are you using to view the data?
>
>
>
> On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote:
>> ;>>> 2011/11/20 20:27 +, Tompkins Neil >>>>
>> Does anyon
What are you using to view the data?
On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote:
> ;>>> 2011/11/20 20:27 +, Tompkins Neil >>>>
> Does anyone know why Chinese characters are not displaying correctly in a
> replicated database on a slave machine ?
;>>> 2011/11/20 20:27 +, Tompkins Neil >>>>
Does anyone know why Chinese characters are not displaying correctly in a
replicated database on a slave machine ? I'm just getting square boxes.
<<<<<<<<
What displays them? it sounds to me as
- Original Message -
> From: "Tompkins Neil"
>
> Does anyone know why Chinese characters are not displaying correctly
> in a replicated database on a slave machine ? I'm just getting square
> boxes.
Random thought: terminal character set ?
--
Bier met
Does anyone know why Chinese characters are not displaying correctly in a
replicated database on a slave machine ? I'm just getting square boxes.
Thanks
Neil
Hi Filipus, all!
Filipus Klutiero wrote:
> Hi,
> an international site has some content in several latin languages, for
> example English and French. Sometimes 2 pages, one in English and one in
> French, have the same name except for an accent (for example, in
> English, Demonstration, in French
ented characters from
their unaccented equivalents? I saw utf8_bin, but that seems very
different from utf8_unicode_ci, which I would like to use if it wasn't
for this problem. I would like something as close to utf8_unicode_ci as
possible.
--
MySQL General Mailing List
For list arch
Running this query:
SELECT *
FROM `tbl_people`
WHERE name = 'Davé'
Returns results like:
'Dave'
I've checked my column, table and database and all are set to
utf8_general_ci collation
And I'm also runnig set names 'utf8' before my select statement.
Am I missing something obvious, I've had a
Jan:
> For example, importing a quote with a "Context" field of:
> The Hitchhiker's Guide to the Galaxy
>
> results in a field containing:
> The Hitchhiker
You are going to have to escape quotes, so your string should
look like this:
The Hitchhiker\'s Guide to the Galaxy
See
ation characters appear to
terminate the reading of a field, whether imported as a TAB file or as
a CSV file.
For example, importing a quote with a "Context" field of:
The Hitchhiker's Guide to the Galaxy
results in a field containing:
The Hitchhiker
whether I use T
s in a separate column instead of
> executing some fancy string checks during select.
>
> Regards,
> m.
>
> -Original Message-
> From: nikos [mailto:ni...@qbit.gr]
> Sent: 19 November 2009 08:41
> To: mysql@lists.mysql.com
> Subject: Select through characters
>
08:41
To: mysql@lists.mysql.com
Subject: Select through characters
Hello list
I have a list of names with english and greek characters.
How can select them separately?
I mean, only greeks or only english.
thank you,
Nikos
--
Wst
Hello list
I have a list of names with english and greek characters.
How can select them separately?
I mean, only greeks or only english.
thank you,
Nikos
On Martes, 6 de Octubre de 2009 11:03:12 Daniel Drake escribió:
> Hi,
>
> I'm having trouble working with specific UTF-8 characters. For
> example, the U+10330 character (UTF8: 0xF0 0x90 0x8C 0xB0).
MySQL currently only supports Basic Multilingual Plane characters: up to 3-
Hi,
I'm having trouble working with specific UTF-8 characters. For
example, the U+10330 character (UTF8: 0xF0 0x90 0x8C 0xB0).
Background: I am trying to clone wiktionary onto local intranets in a
series of (disconnected) schools in Nepal. I'm encountering these
problems when trying
>-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
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 Productions
http://www.upscene.com
Download
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
Hi
How can I specify 'unprintable' characters is a MySQL regexp ?
Query is (example only):
SELECT something FROM table WHERE column REGEXP 'Ã\\xA0';
I'm looking for an equivalent of the search part of a sed expression like
this:
s/Ã\xA0/à/g
which means I want to
IL PROTECTED]>
To: Paul Nowosielski <[EMAIL PROTECTED]>; mysql@lists.mysql.com
Sent: Monday, December 1, 2008 6:42:19 PM
Subject: RE: regular expressions matching only numeric characters in order
Hi
I am a bit of novice at Regexp, but I believe this will work for you
(\d+\d+\d+).*(\d+\
Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.
(333)333-
333-333-
33
So I am wa
z" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Monday, November 24, 2008 9:21 AM
Subject: RE: Special Characters
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent
>-Original Message-
>From: Mike Blezien [mailto:[EMAIL PROTECTED]
>Sent: Sunday, November 23, 2008 4:59 PM
>To: MySQL List
>Subject: Special Characters
>
>Hello,
>
>we are in the process of setting up a database with members data and
>other info.
>We&#x
Hello,
we are in the process of setting up a database with members data and other info.
We'll need to enter names with special characters, i.e:
apostrophes: O'Rourke
tildes: Magglio Ordóñez
titlo: Anaïs
hyphen: Chun-Myers
Is there some special table setup required, collation
Hi all:
I am trying to build a FULLTEXT index with several particularities. It
must ignore some special characters inside index words. For example:
If I have the text:
I'll go to the ci[ne]ma.
I want the FULLTEXT include the word cinema, not ci[ne]ma nor ci or ne or
ma. So, I want the
I've extracted text from approx 1600 pdf files using pdftotext.exe and
inserted it into a table.
Now I see there are form feed characters in the field, and I would suspect
other special characters, also.
I'm not having much luck trying to remove them.
Any pointers appreciated.
Thanks,
David
set, at least not out of
the box. Therefore you cannot get MySQL to convert CP-1252 characters to
UTF-8. You could try CP-1251, I didn't test that.
- Sourcing a file containing one of these troublesome characters into the
MySQL CLI will trigger the problem, because the data is sucked in as-is.
ubject: Re: data truncation warnings by special characters
I have some php code I use to import data that is a bit more flexible and
robust than the load data statement in MySQL If you use php I can share
the code with you.
C.R.Vegelin wrote:
Hi Jerry,
Sorry, I should have mentioned that I
, April 18, 2008 2:30 PM
Subject: RE: data truncation warnings by special characters
>-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get s
t; <[EMAIL PROTECTED]>
To: "'C.R.Vegelin'" <[EMAIL PROTECTED]>;
Sent: Friday, April 18, 2008 2:30 PM
Subject: RE: data truncation warnings by special characters
>-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2
>-Original Message-
>From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@lists.mysql.com
>Subject: data truncation warnings by special characters
>
>Hi List,
>
>I get strange "Data truncated for column Descripti
>-Original Message-
>From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@lists.mysql.com
>Subject: data truncation warnings by special characters
>
>Hi List,
>
>I get strange "Data truncated for column Descripti
Hi List,
I get strange "Data truncated for column Description" warnings
when loading a tab separated file with special characters.
The definition of the target table is:
CREATE TEMPORARY TABLE tmp
( Code CHAR(8) NOT NULL,
Description TEXT NOT NULL,
KEY Code (Code)
) ENGINE = MyIS
> I get incorrect result when searching for the norwegian character 'å'
> using LIKE. I get rows with 'a' in it, and visa versa if I search for
> 'a', I get results which has 'å' in it in addition to the ones with 'a'.
Make sure that your table has:
charset=utf8
collation=utf8_norwegian_ci
A
;%å%';
+--+
| name |
+--+
| Bar |
| Båt |
+--+
mysql> SELECT * FROM names WHERE name LIKE '%a%';
+--+
| name |
+--+
| Bar |
| Båt |
+--+
Searching for strings with other norwegian characters seams to work:
mysql> SELECT * FROM names WHERE name LIKE '
t to a command window seems to do some automatic
conversions.
Whenever I deal with "other" characters, I get a brain cramp. You should see
me working with Chinese.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan 18, 2008 2:27 PM, Jerry Schwar
Jerry Schwartz schrieb:
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan
Jerry,
On Jan 18, 2008 2:27 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> I am having trouble inserting special characters into a table. I am using
> the MySQL client. I put the following commands into a text file (I'm on
> WinXP, using Notepad), copy them, and paste them in
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY TABLE `giiex
w.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 03, 2007 3:09 PM
> To: mysql@lists.mysql.com
> Subject: speical characters in text column
>
> hi friends,
>
> i s
hi friends,
i searched on google but not file a solution.
is there a way that i can store special characters (return, new line, tab,
etc) into mysql (ver. 4.1.12) table with text type?
i use textarea tag for user to enter the text.
my goal is to store/display EXACTLY what user entered in
Olav Mørkrid schrieb:
> hello
>
> i would like to search a table column for a range of non-ascii
> characters, or a particular non-ascii character. how can i do this?
Maybe via a inverted regular expression [1] like this?:
SELECT * FROM WHERE RLIKE '[^-, a-zA-Z
Hi,
Olav Mørkrid wrote:
hello
i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?
the column can be any string like "hello, world" or "norwegian
characters æøå here".
refer to these pseudo exam
hello
i would like to search a table column for a range of non-ascii
characters, or a particular non-ascii character. how can i do this?
the column can be any string like "hello, world" or "norwegian
characters æøå here".
refer to these pseudo examples:
SELECT * FRO
[snip]
Try:
replace(replace(dealerLong, '\n', ''), '\r', '')
[/snip]
Didn't work, perhaps because they are hidden. I ended up taking the long
road;
update table set foo = replace(HEX(foo), '0D', '');
update table set foo = UNHEX(foo);
HEX allowed me to see the carriage return (0D) and then use
file set dealerLong = replace(dealerLong, char(13), "") where
id = '130';
has no affect. So I need to see all of the characters inn the column so
that I can determine how to replace.
Can someone point me in the correct direction? I sure do appreciate any
help that you can give
rofile set dealerLong = replace(dealerLong, char(13), "") where
id = '130';
has no affect. So I need to see all of the characters inn the column so
that I can determine how to replace.
Can someone point me in the correct direction? I sure do appreciate any
help that you can give me.
--+
You will note the way that the column displays, appearing to have no
data at all. This is typically caused by having a carriage return
somewhere in the column.
update profile set dealerLong = replace(dealerLong, char(13), "") where
id = '130';
has no affect. So I n
I found that using version 5.1 of the ODBC connector solved our problem with
Chinese characters. It might solve the problem with the pound sterling sign.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 24, 2007 5:24 AM
> To: MySQL General
> Subject: Problem with characters
>
> I have a new setup with mySql version 4.1 and myODBC version 3.51
> running on Windows 2k3 standard
>
> In the database we ha
; Sent: Monday, September 24, 2007 5:24 AM
> To: MySQL General
> Subject: Problem with characters
>
> I have a new setup with mySql version 4.1 and myODBC version 3.51
> running on Windows 2k3 standard
>
> In the database we have something like "And this is £200" and when w
I have a new setup with mySql version 4.1 and myODBC version 3.51
running on Windows 2k3 standard
In the database we have something like "And this is £200" and when we
write this out in ASP we get "And this is ?200" The same happens for
some other symbols like the copy write symbol (c in a cir
*From: VeeJay* <[EMAIL PROTECTED]> To: mysql@lists.mysql.com,
[EMAIL PROTECTED]
Date: Fri, Aug 10, 2007 at 8:19 AM
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command
in addition to the correct character-set also set the appropriate
collation sequence
suomi
VeeJay wrote:
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command like:
se
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command like:
select * from employees where fname LIKE 'Å%';
I get results starting with English alphabet 'A' but not with 'Å'
Hi all,
Here I am, following up to my own post - available below and at
http://lists.mysql.com/mysql/208343 - with a solution (basically, a
"workaround").
To summarize: I couldn't enter Portuguese accented characters in
"MySQL monitor" (MySQL command line / console c
Hi all,
First of all, sorry for the lengthy subject, but it serves to describe
my problem:
I'm having problems entering Portuguese accented characters (with a
Portuguese keyboard) in "MySQL monitor" (MySQL command line / console
client), when I'm in a SSH (Secure Shell)
I can't speak to your GUI tool, but here's some general pointers:
1. You have to be absolutely sure that your system can in fact render Myanmar.
- so ensure that at least your browser can view proper Myanmar
characters - see http://www.columbia.edu/kermit/utf8.html.
This page has a samp
to a mysql table from a java
application. i can input and output our fonts in application program,
but,
i can only see ??? characters in MySQL browser\'s table. How can i
store and retrieve our fonts in mysql???
Thanks for any help!!!
purple.
--
MySQL General Mailing List
For list arch
Hello everybody,
I want to store Myanmar unicode data in MySQL
database. Then, I want to make data manipulation with it. Firstly, i
tried to input Myanmar characters in MySQL's GUI tool. i chose Myanmar
keyboard and installed Myanmar font in tool. But, i couldn't ty
ministrator on Mac OSX.
I've received a sql dumpfile from a database we need to restore on
our development environment. In this file there are characters with
accents and apostroph like "l'état" for example. When running the
file I get an sql syntax error. When I remove the ac
Hi all,
mysql 5.0.37 on CentOS4, default install using Mysql's rpm and using
the standard mysql querybrowser and administrator on Mac OSX.
I've received a sql dumpfile from a database we need to restore on
our development environment. In this file there are characters with
a
I believe varchar(50) means 50 characters, not 50 bytes.
So, usually I don't care when designing table schema at all, for
Japanese characters.
On 7/3/07, Cathy Murphy <[EMAIL PROTECTED]> wrote:
I am limiting text to 50 chars in mysql field by varchar(50) ( UTF-8
enabled)
but what
From my experience with InnoDB,
IF the field is an index, it will use 3 bytes per character. So
VARCHAR(50) = 150 bytes, when fully populated. (+ 1 for the length =
151 bytes.)
IF the field is not an index, each character will consume between 1 and
3 chars. So VARCHAR(50) = 51 -> 151 char
I am limiting text to 50 chars in mysql field by varchar(50) ( UTF-8
enabled)
but what if the user enters 50 japanese chars, does mysql accomodate it OR
we have to consider some buffer during design ?
--
Cathy
www.nachofoto.com
back, it
results in a "SQL Syntax error", thereby stopping replication...
4) and each time this happens the very last statement in the relay log
before mysql rotates the log file after reconnecting to the master (see
above error) , usually has garbage characters or some sql stateme
Do you have to do something special with InnoDB tables to accept
various character sets like accented, European characters? Using the
default, these accented characters come out as garbage.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
UTF-8 to Windows or vice versa.
You should see that the accented characters change, so you'll have an
example in front of you.
The browser will typically render the page according to the character set
specified in the HTML header (I think), or it makes a best guess, or it uses
its default. Alt
94) ). But when I
compare both the characters:
select char(160), char(194);
... I get:
+---+---+
| char(160) | char(194) |
+---+---+
| | |
+---+---+
... and both the and results are in reverse video. The
*looks* like the stu
Am 05.02.2007 um 18:11 schrieb Chris White:
SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small
eta]'
that *should* ( see disclaimer ;) ) give you what you need
Yes, it does.
I should have also asked for SELECT DISTINCT fieldname ... in the
first place, but looking at your an
Sven Fuchs wrote:
These characters are stored/retrieved correctly. But they are wrongly
regarded the same character by statements like SELECT * FROM tablename
WHERE fieldname LIKE '[greek small eta]'
The database's character-set is set to "UTF-8 Unicode (utf8)" and
MySQL 4.1.22 seems to treat the following characters as equal
(comparing them as varchar values):
U+03B7 (206 183) greek small letter eta
U+1F75 (225 189 181) greek small letter eta with accent oxia
U+1FC4 (225 191 135) greek small letter eta with accent persispomeni
and accent
94) ). But when I
compare both the characters:
select char(160), char(194);
... I get:
+---+---+
| char(160) | char(194) |
+---+---+
| | |
+---+---+
... and both the and results are in reverse video. The
*looks* like the stuff I&#x
Hi
I have to move the date to one DB to another by live, so i wrote a Java
program which will read the data from Sourse DB, and make the data as a
Strings which nothing but insert statements with data. I simply add these as
a batch and fire them to destination. Everything is fine, if simple data
Hi Barbara,
The hex value '3F' represents the question mark,
which means your server CAN'T convert the characters
correctly from your client.
Regards,
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 2006-11-28 11:16:09:
> All,
>
> I have an applica
All,
I have an application in which I am trying to insert some traditional Chinese
characters. The insert statement probably won't cut and paste correctly but it
is: insert into "TKTS13" values (2,'ÄãºÃ', 'ÄãºÃ');
I have used this website
http://pe
On 10/25/06, Mark <[EMAIL PROTECTED]> wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such a
Mark wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database
by different people so there was no consistency in the format used.
There are now names entered such as:
Smith, John S.
Doe - Jane
, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Mark [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 25, 2006 1:18 PM
> To: mysql@lists.mysql.com
> Subject: Remove unwanted characters from a name field
>
> I have a field called name which stores a pe
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such as:
Smith, John S.
Doe - Jane W.
Doe John
har length
depends on your MySQL version and character set.
5.0.3 and later handles upto 64k chars.
See: http://dev.mysql.com/doc/refman/5.0/en/char.html
/Johan
Peter Van Dijck skrev:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I hav
> wrote:
Peter Van Dijck wrote:
> Hi,
> URL's have a practical limit of 2083 characters it seems. To store
> these in a space efficient way (I have 1,000,000s of url rows), what's
> the best approach? varchar has a 255 maximum, right? Should I just use
> TEXT? I'm
Peter Van Dijck wrote:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am
Hi Peter,
I'd thought I'd just mention that the varchar length
depends on your MySQL version and character set.
5.0.3 and later handles upto 64k chars.
See: http://dev.mysql.com/doc/refman/5.0/en/char.html
/Johan
Peter Van Dijck skrev:
Hi,
URL's have a practical limit of 208
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like this:
&q
COMPILED_CHARSETS
lists in configure.in.
Reconfigure, recompile, and test.
Thanks
Visolve DB Team.
- Original Message -
From: "khaing su yee" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 01, 2006 9:28 AM
Subject: want to insert unicode myanmar characters into MySQL data
I use Toad for MySQL 2.0 and SQLyog 5.02.
I want to insert unicode myanmar characters.
I change uft8 charset and utf8_unicode_ci collation.
But I can't insert myanmar characters.
What is needed to do?
Please tell me.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Adams wrote:
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
> I recommend "LEFT( )".
>
> If you are looking to do it in PHP then this is the wrong email list.
>
> Good luck.
Sorry about that I realized I picked the wrong mailing
1 - 100 of 480 matches
Mail list logo
