Hi Gurus
I have a database full of text that I have downloaded from a website (ftp download, read file, parse file (i.e. break it down into
parts), move it into a table, etc...).
My next step now is to load this data into a MySQL database on the net for a PHP website.
HOWEVER, the funny characters on the original website (e.g. unicode characters, etc.... etc...) are doing really nasty things. The
MySQL thaat I use does not support unicode, so I want to reduce it down to just asci characters (to keep it simple).
I have two questions:
a. how do I make sure that all the data in my database are ascii characters?
b. do you agree with my course of action or do you suggest another way?
TIA
- Nicolaas 1 1292
"WindAndWav es" <ac****@ngaru.c om> wrote in message news:SX******** *************@n ews.xtra.co.nz. .. Hi Gurus
I have a database full of text that I have downloaded from a website (ftp download, read file, parse file (i.e. break it down into parts), move it into a table, etc...).
My next step now is to load this data into a MySQL database on the net for a PHP website.
HOWEVER, the funny characters on the original website (e.g. unicode characters, etc.... etc...) are doing really nasty things.
The MySQL thaat I use does not support unicode, so I want to reduce it down to just asci characters (to keep it simple).
I have two questions: a. how do I make sure that all the data in my database are ascii characters? b. do you agree with my course of action or do you suggest another way?
TIA
- Nicolaas
If anyone is interested in an answer to this question, I basically did the following to find out where the non-asci characters where
and then replaced them.
function ascionisetable( mytable as string)
dim r as recordset
dim f as field
dim x as string
dim y as long
dim i as long
dim ii as long
dim s as string
set r = currentdb.openr ecordset(mytabl e)
do while not r.eof
for each f in r.fields
s = nz(f.value, "")
ii = len(s)
for i = 1 to ii
x = mid(s,i)
y = ascw(x)
select case y
case is<0, is > 128, 64, 34, 39 'these are special characters in html (e.g. >, <, ", ')
'record and replace (using conversion table
next i
next f
r.movenext
loop This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dan Stromberg |
last post by:
I've written up a page about how to convert native binary data to
another platform's native binary data, as I did some fortran data
conversions for a client.
The programs and documentation are at:
http://dcs.nac.uci.edu/~strombrg/converting-binary.html
So far, the page includes a variety of programs written in C or python to
do:
|
by: Govind |
last post by:
Hi All,
I want to Convert 32 bit integers to byte in right alighed format .
For 32 = the usual way is BitConverter.GetBytes(int32)==> xx xx 00 00 , but
i want right aligned like 00 00 xx xx.Is there any way.
Regards,
Govind.
|
by: mustafa |
last post by:
Dear sir ,
I have built my application in visual basic 6.0 and
crystal Report8.5 , Now i migrated my application to
VB.net using the upgrade wizard.My visual basic form is
upgraded to vb.net but my .dsr file that i created using
crystalReport is not migrated , when i try to convert it
into .rpt file using add new item in Vb.net Envs it give
me the error in the log file saying,
|
by: Pete Davis |
last post by:
I've never done this in C# so I don't know what the appropriate way of doing
it is.
I've got an array of bytes and I need to convert the array into "usable"
data. For example, the first 4 bytes need to be converted to an enum. The
next 4 bytes to a 32-bit int. And so on. I'm basically populating a struct
with the data. How does one do this in C#?
Thanks.
|
by: robert d via AccessMonster.com |
last post by:
I'm looking at converting DAO to ADO in my app. All of my DAO connections
are of the following structure:
Dim wsName As DAO.Workspace
Dim dbName As DAO.Database
Dim rsName As DAO.Recordset
Set wsName = DBEngine.Workspaces(0)
Set dbName = wsName.OpenDatabase(CurrentProject.FullName)
Set rsName = dbName.OpenRecordset("SQL Statement")
| |
by: Sharon |
last post by:
I have a buffer of byte that contains a raw data of a 1 byte-per-pixel
image data.
I need to convert this buffer to a Bitmap of Format32bppArgb and to a Bitmap
of Format24bppRgb.
Can anybody tell how to do it?
------
Thanks
|
by: Bob Alston |
last post by:
Anyone have experience with converting an access app from Jet database
to Mysql? I am specifically looking for any changes I would have to
make to my access forms, queries, modules, vba code, etc. I understand
there are some data format differences in text field types and date
types that need to be addressed if converting from Jet to Mysql. But
other than things that have to be addressed when converting, what other
changes must I make?...
|
by: SLC via DBMonster.com |
last post by:
Hello I'm a newbie to this and I need help, please
My question is, we currently have a IDMS db and will be converting to DB2.
What are the things I should do? The IDMS has not been documented very well,
and there are a number of duplicate fields. I was thinking about
documenting all the tables with fields attributes, and documenting the fields
to the 150 screens in this program. We also that about doing a CRUD matrix
to see what it...
|
by: psbasha |
last post by:
Hi ,
When ever we read any data from file ,we read as a single line string ,and we convert the respective field data available in that string based on the data type ( say int,float ).
Please suggest me which is the best way of handling the file data.
I- Method:
----------------
Store as single line string data's(upto end of file ) in a list and make use of this string list for the entire application.
|
by: Krishna Ladwa |
last post by:
In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears when you convert the varchar column to text column.
Do this through Enterprise Manager Console
Create a New table with a column as varchar datatype from Enterprise Manager table created Open the table and add one row Successfully added the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |