charset

[Borja Gonzalez]

Hi, I'm a newbee, also in english.
The thing is that I have a kind of javascript based search engine that
use a .txt as its database, it has several field delimited by tabs.
What I want to do is using the same application to diferents projects. I
just change the look, the datas and I have another beautiful serach
engine.
How I don't know much about javascript, I made a PHP script that builds
a .txt with identical structure to the one I have just explained and
fill it with the datas. But It doesn't work.
I have noticed that the javascript says anywhere something about
"unicode" charset. The PHP script make a entirely new file each time
from a Access database, I do this because I needed to modify some
database content in some fields, and I think that It doesn't use the
same charset that javascript. I belive this because I tested to paste
same records directly from txt formed by PHP script to original txt and
when saving WordPad tell me something about that I'm saving without
format and I am going to loose any format issue. And after this, I could
see throught the serach engine the records pasted in the txt.

I am using WinXP, Nusphere, Dreamweaver, etc, everything in spanish (so
the charset, I think It is ISO LATIN number-015, with Euro, I'm just
guessing)

Thank's a lot for any help.

Borja González
[email]oavicena123@yahoo.es[/email]

Remove 123 manually.


--
Posted via Mailgate.ORG Server - [url]http://www.Mailgate.ORG[/url]

[Daniel Tryba]

Borja Gonzalez <borja@nccextremadura.org> wrote:

> How I don't know much about javascript, I made a PHP script that builds
> a .txt with identical structure to the one I have just explained and
> fill it with the datas. But It doesn't work.

What doens't work? You can't create the file or you can't reproduce the
required structure of it?

[charsets]

> I am using WinXP, Nusphere, Dreamweaver, etc, everything in spanish (so
> the charset, I think It is ISO LATIN number-015, with Euro, I'm just
> guessing)

Take a look at the thread '"smart" quotes in PHP'
(Message-ID: <Xns943380961AE3Awwwnowherefoo@24.24.2.166>) which might
give you some hindts on how to convert oce you figure out whtat the
actual encoding is.

--

Daniel Tryba

[Borja Gonzalez]

Hi,

> What doens't work? You can't create the file or you can't reproduce the
> required structure of it?

What it doesn't work is the javascript search engine. I mean, I manage
to build the file
and it looks like the one that i need, but the javascript doesn't read
it.

> [charsets]

> > I am using WinXP, Nusphere, Dreamweaver, etc, everything in spanish (so
> > the charset, I think It is ISO LATIN number-015, with Euro, I'm just
> > guessing)

>
> Take a look at the thread '"smart" quotes in PHP'
> (Message-ID: <Xns943380961AE3Awwwnowherefoo@24.24.2.166>) which might
> give you some hindts on how to convert oce you figure out whtat the
> actual encoding is.

I have read it but and... correct me I am wrong:
The original database was encoded using unicode, this I have read from
the javasript code:

<object id="db" CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83"
VIEWASTEXT>
<param NAME="DataURL" VALUE="datdb.dll">
<param NAME="UseHeader" VALUE="True">
<param NAME="CharSet" VALUE="unicode">
<param NAME="FieldDelim" VALUE=" ">
</object>

The new database I have built It in not unicode but other encoding
system, so I anyhow have
to convert it:

$fp=fopen("datdb.txt","w");

$cabecera="\"Titulo\"\t\"Descripcion\"\t\"Localida d\"\t\"Seccion\"\t\"Enlaces\"\t\"Correo\"\r\n";
fputs($fp, $cabecera);
$link=mysql_connect("localhost");
mysql_select_db("test",$link);
$query="SELECT Titulo,Autores,Tema,Archivo FROM abstracts";
$resultado=mysql_query($query,$link);
while ($regdb=mysql_fetch_array($resultado, MYSQL_ASSOC)) {
$regtxt="\"<a href=\"\"abstracts/";
$regtxt.=$regdb["Archivo"];
$regtxt.="\"\" class=\"\"rsURL\"\">";
$regtxt.=ereg_replace("\r\n","
",ucfirst(strtolower($regdb["Titulo"])));
$regtxt.="</a>\"";
$regtxt.="\t\"";
$regtxt.=ereg_replace("\r\n"," ",$regdb["Autores"]);
$regtxt.="\"\t\"";
$regtxt.="Badajoz";
$regtxt.="\"\t\"";
$regtxt.="Sesiones, " . $regdb["Tema"];
//$regtxt.="\"\t\"<span></span>\"\t\"<span></span>\"";
$regtxt.="\"\r\n";
fputs($fp, $regtxt);
fclose($fp);


And my question is:
How do I manage that php script write the file encoded in unicode?

Thanks a lot
Borja


--
Posted via Mailgate.ORG Server - [url]http://www.Mailgate.ORG[/url]

[Daniel Tryba]

Borja Gonzalez <borja@nccextremadura.org> wrote:

>> Take a look at the thread '"smart" quotes in PHP'
>> (Message-ID: <Xns943380961AE3Awwwnowherefoo@24.24.2.166>) which might
>> give you some hindts on how to convert oce you figure out whtat the
>> actual encoding is.

>
> I have read it but and... correct me I am wrong:

[snip]

> The new database I have built It in not unicode but other encoding
> system, so I anyhow have

You know which?

[some string]

> fputs($fp, $regtxt);
> fclose($fp);
>
>
> And my question is:
> How do I manage that php script write the file encoded in unicode?

As already mentioned in the thread mentioned above:
1-utf8_encode
2-iconv
3-str_replace

1 is preferable but your data needs to be in iso-8859-1 (if you are
using iso-8859-15 you could translate the generic curreny char to the
EUR manually)

2 is optionally, so your server might lack iconv support

3 if all else fails your last hope.

--

Daniel Tryba

[arthur tieck]

When we open a file (made in dreamweaver: " xxxxx.cfm" ) with contribute, choose edit, then publish: all characters like ?, ?, ?, ? in the body become unreadable. :(

[mzanime.com]

Do you have a meta charset tag in the header? And if so, what charset are you
using?

iso-8859-1 or UTF-8 should cover all of those characters. If you have either
of these, then how are those specific characters encoded in the HTML?