Hi
I don't use phpMyAdmin myself and I can't remember if it supports UTF-8
encoding
Whichever extension that your PHP is using is likely doing a conversion.
this is something that the MySQL libraries handle.
You can use this to extract the data from the tables and save it.
As a test, dump a
--
$query1 = "SELECT distinct link_id, url, title, description, $fulltxt, size
FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)";
$result = mysql_query($query1);
echo mysql_error();
and what does $fulltxt contain when you get the error
Thanks Neil,
But what would be the best way to convert my Arabic Texts which were stored
through a php script into a latin1 table back to UTF-8.
I wonder WHY is it displayed correctly when retrieved through the php
scripts (!!??)
M.
From: Niel Archer <[EMAIL PROTECTED]>
Reply To: php-db@
Thank you very much.
Could you give me a rough idea of what the MySQL query would look like?
I am trying to work out the syntax using string functions like LOCATE,
INSTR, SUBSTRING and SUBSTRING_INDEX.
Many thanks
BMA
Steven Cruz wrote:
> I use to perl scripts to do something like this. But y
I use to perl scripts to do something like this. But you just back and forward
from the location in the string you are. You are count for word bounderies, in
short, mostly white spaces. Next you count the number of characters, and
substring!
>
> From: Miguel Guirao <[EMAIL PROTECTED]>
> Date: 2
I guess you will still need to get the whole texts, but do the selecting
befores displaying results. There are functions to to select an amount of
text of certain lenght, starting at certain point of the string.
-Original Message-
From: benmoreassynt [mailto:[EMAIL PROTECTED]
Sent: Viern
Hi
If you're storing non-latin character in a latin-1 table you are bound
to get this problem. phpMyAdmin is simply showing you what you put
there as far as it is concerned.
You should switch to using an alternative encoding for the character set.
UTF-8 would likely be best for you. Back up al
Hi,
Not really sure if this is possible.
I am using a fulltext search to search through very large entries. Basically
an entry might contain 200,000 words, which are searched for exact matches.
What I want to do is SELECT, say, the 300 words surrounding the exact match
from the 200,000 word entr
Chris Carter wrote:
>
> I am now trying to run PHP using apache on localhost. Can you please
> advice:
>
> 1) What exactly I need to download for running PHP on Apache.
> 2) What should be the location of the downloaded PHP
> folder/file/executable so that it interacts easily with Apache.
> 3) S
Chris Carter wrote:
>
> I am now trying to run PHP using apache on localhost. Can you please
> advice:
>
> 1) What exactly I need to download for running PHP on Apache.
> 2) What should be the location of the downloaded PHP
> folder/file/executable so that it interacts easily with Apache.
> 3) S
Hi
Using PDO to prepare a query, bind som values to it (using ? Placeholders)
and then executing it - how do i get the actual query afterwards? With the
correct inserted values.
It is needed logging purposes.
I haven't been able to find any method or property that gives me this
information.
Th
Would you please give any suggestions or hints about storing data into
MySQL.
I have a site where I use MySQL database to store usually Arabic texts. I
use a custom contorl panel to store/retrieve the Arabic texts from the
database. Everything up to now is OK.
But When I try to open the data
D.
Go to the manual at http://be2.php.net/manual/en/function.rand.php and
look at the User contributed notes further down the page. You'll find a
couple of solutions.
Whatever you do, you will presumably need to check the generated number
against the db to see if it is already in use and, if
X-No-Archive: true
Hello,
I'm learning PhP and trying to write a library catalogue system, that uses a
PostgreSQL back-end. My db looks like this ...
http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql
I had originally planned to have a username in place of 'card_number', but
realised
14 matches
Mail list logo
