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
been able to
If you insert new records (or update existing) containing correct UTF-8
data to the production database using a mysql client, does the data save
correctly?
Could it be your data source for the production database has/is incorrectly
handling the charset prior to the data being stored in the product
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.
What it sho
Addslashes()
http://us3.php.net/manual/en/function.addslashes.php
-M
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:28 PM
To: MySQL List; PHP eMail List
Subject: Characters
I am inserting a file via a PHP form. It works great, however, i
On 07-Jul-01 Michael Collins wrote:
> I understand that any ASCII character can be stored within any of the
> non-numeric type fields. Does this mean just characters 1-255?
>
> What happens if I try to import a non-ASCII character, let say, into
> a VARCHAR field? Is it discarded or will I sim
Michael Collins wrote:
> I understand that any ASCII character can be stored within any of the
> non-numeric type fields. Does this mean just characters 1-255?
No, MySQL supports also multibyte character sets used in Asian countries. This means
much wider range than 256.
> What happens if I
an Kaney <[EMAIL PROTECTED]>
> To: Selvin Sakal <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: characters - URGENT!!
>
> I've noticed some people seem to be forgetting about their
> middleware when approaching a programming challenge. In many
> cases, inform
I've noticed some people seem to be forgetting about their
middleware when approaching a programming challenge. In many
cases, information to and from the database is processed using C,
java, perl, php, etc. These languages can do pre and post
processing of data. I have found this approach is e
I would say it depends on what you're using to put the data into your
database.
PHP comes with several functions that make this sort of thing very easy
(strip_tags, for example, will remove all HTML tags from a string)
If you're using Perl or something else that supports regex, I think that's
go
