Home > Archive > MySQL Server Forum > August 2005 > C API, setting language, MyISAM









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author C API, setting language, MyISAM
Fábio Emilio Costa

2005-08-21, 8:23 pm

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

I'm working in a project in C++ using MySQL C API (Win98/Dev-C++
4.9.9.8/MySQL DevPak/MySQL 4.1.13) and I want to know if it's possible
to setup the server environment language (--language) via
mysql_options() function.

Also, I want to know if it's possible to setup a table to MyISAM
instead of InnoDB via C API. I have some tables that I want to use
FULLTEXT in them and it only works in MyISAM.

- --
Thanks!

Fabio Emilio Costa ICQ #:173799674 Borda da Mata - MG - Brazil
fabiocosta0305@yahoo
.com.br MSN: hufflepuffbr@hotmail
.com
Yahoo!:hufflepuff030
5 Jabber: SamWeasley@jabber.org

"Copy! Be Free! Don't be a Muggle! Use Free Software!"

HPCode (1.1)-H PS++COS+++POA+++GOF+
++*OOTP+++ FF++ QB
CH+++DD+++HB++HM+PO+
+TR+++AR+++AT+++*MS+
++
NL/Gi-BW/Fl-RB/Ol-RW/He-HP/Lu-RL/To

HPCode - www.hogwarts-library.net/common/hpcode.html


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDCScfV8k+DWXy
GXgRAntaAJ46XXjWRgbP
Zf62E+TEndadAMVk0QCd
FgCe
k9EjluSYDzoaw66/Xu5QXKU=
=AHO/
-----END PGP SIGNATURE-----
Gordon Burditt

2005-08-22, 3:23 am

>Also, I want to know if it's possible to setup a table to MyISAM
>instead of InnoDB via C API. I have some tables that I want to use
>FULLTEXT in them and it only works in MyISAM.


If you are using the C API to create the table, use the ENGINE=MyISAM
option on the CREATE TABLE query. If the table already exists and
you want to move it to MyISAM, "ALTER TABLE foo ENGINE=MyISAM".

Gordon L. Burditt
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com