|
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
Ruey
µù¥U®É¶¡: 2003-03-12 ¤å³¹: 1698 ¨Ó¦Û: tunglo
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤Q¤ë 12, 2003 9:02 pm ¤å³¹¥DÃD: VFP and PostgreSQL ªº¤¤¤å¸Ñ¨M¤è®×(Âà¶K) |
|
|
§Ú¥u´£¨Ñ¸ê®Æ.§Ú¹ïpqSQL¤£¼ô.
¨Ó·½:¸ê®wºô
http://www.pgsql.com.tw/modules.php?op=modload&name=Forum&file=viewtopic&topic=399&forum=1
ì¤å
½Ð±Ð¦U¦ì:
§Ú¨Ï¥Î RedHat 8 ¤º©w¦w¸Ë PostgreSQL, ¤º©wÅã¥Ü»y¨¥¬°¤¤¤å, «eºÝ¦w¸Ë psqlodbc-07_02_0005, ¦b VFP ¤¤¶}±Ò¤@Ó RemoteView, ¬Ý¨ìªº¤¤¤å³£¬O¶Ã½X; ¦ýY¦bºô¶¤¤¥H PHP ¬d¸ßÅã¥Ü¬O¥¿±`ªº.
¥Î psql -l ¬d¬Ý¸ê®Æ®w, ¨äµ²ªG¥H¤¤¤åÅã¥Ü "½s½X" ¬° SQL_ASCII.
½Ð°Ý§Ú¦b«e, «áºÝ¦UÀ³°µ¤°»ò³]©w, ¤~¯à¦b«eºÝ¥¿½TÅã¥Ü¤¤¤å?
¤è¦¡¤@:
1.postgresºÝ:¥Îeuc_tw½s½X
2.vfpºÝ :sqlconnect()«á
¥ý¤Uset client_encoding to 'big5'
©Î
3.vfpºÝ(remote view)dbcùØ->postgresqlÅX°Êµ{¦¡->³]©w->datasource->connect setting:
¤Uset client_encoding to 'big5'
¤è¦¡¤G:
»P¥ÎþÓª©¥»ªº psqlodbc µLÃö, ¤]¤£¥Î¦b«e, «áºÝ°µ¦ó³]©w, ¥t½Ð¹ï·Ó PostgreSQL 7.2 ªº Administrator's Guide ªº ªí 5-2, ¬Ý¤@¤U server ºÝ»P client ªº½s½XÂà´«¹ï¬M, ¥H§ÚªºÀô¹Ò¨Ó»¡, server ºÝªº½s½X¬O SQL_ASCII, «h client ºÝªº½s½X¦³ SQL_ASCII, UNICODE, MULE_INTERNAL ¤TºØ, µM«á¦bµ{¦¡¤¤¥H SQLCONNECT() <¥»¨ç¼Æ¨Ï¥Îªk½Ð°Ñ¦Ò VFP Help> ³s±µ server ºÝ¤§«á, ¦A¥H SQLEXEC(nConnectionHandle, "SET CLIENT_ENCODING TO 'SQL_ASCII';") ´N¦¨¤F. ¦pªGÁÙ¬O¥X²{¶Ã½X, ´N¦A´« UNICODE, MULE_INTERNAL ¸Õ¸Õ.
´£¨Ñµ¹ VFP ªº¦P¦n°Ñ¦Ò.
¤è¦¡¤T
¥H¤U¬°×§ïªºcode
/*********************************
¨ç¦¡¦WºÙ¡G23.deWord( );
¥\¡@¡@¯à¡G±N¦r¦ê°µ«O¯d¦rªºÀˬd "¥\" => "\¥\"
¶Ç¡@¡@¤J¡G
¶Ç¡@¡@¦^¡GString
§@¡@¡@ªÌ¡Gcolin
§¹¦¨¤é´Á¡G2002/04/03
*********************************/
public String deWord(String str){
if(str==null || str.length()<1) return "";
String str2=getUnicode(str);
if(str2.indexOf("\\")!=-1){
String temp="";
String str3=""; //¦s©ñÂà´««á¤§µ²ªG
for(int i=0;i{
str2=str.substring(i,i+1); //¤¤¤å
temp=getUnicode(str2); //unicode
if(temp.indexOf("\\")!=-1){
str2= "\\"+str2;
}
str3+=str2;
}
str=str3;
}
if(str.indexOf("'")!=-1){ //Àˬd¥]§t'
int pos=0;
while(str.indexOf("'",pos)!=-1){
pos=str.indexOf("'",pos);
str=str.substring(0,pos)+"\\'" + str.substring(pos+1);
pos+=2;
}
}
return str;
}
public String getUnicode(String s)
{
//s = check_null(s);
if (s.length() != 0 )
{
try{return new String(s.getBytes("big5"), "iso-8859-1");}
catch(Exception e){e.printStackTrace();}
}
return "";
}
¤è¦¡¥|
¤É¯Å¨ì7.2.3-5.80
¤w¸Ñ¨M! _________________ #############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~ì¨Ó©¯ºÖ¨º»ò²³æ!!
¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
#############################
Ruey ¦b ¬P´Á¤» ¤Q¤ë 25, 2003 7:03 pm §@¤F²Ä 2 ¦¸×§ï |
|
¦^³»ºÝ |
|
|
violetlkk
µù¥U®É¶¡: 2003-06-21 ¤å³¹: 82 ¨Ó¦Û: kaohsiung
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤ë 13, 2003 1:23 am ¤å³¹¥DÃD: |
|
|
Ruey ¯u§Q®`
³s¦b¸ê®wºôªº¸ê®Æ³£§ä±o¨ì
¨ØªA,¨ØªA...
²{¦b·sª©ªºpostgresql
¥unserverºÝ»PclientºÝªº½s½X³]©w¨S°ÝÃD,¤¤¤å¦r´N¨S°ÝÃD
¤]¤£·|¦³'¥\','³\'...µ¥°ÝÃD |
|
¦^³»ºÝ |
|
|
Ruey
µù¥U®É¶¡: 2003-03-12 ¤å³¹: 1698 ¨Ó¦Û: tunglo
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤ë 13, 2003 1:48 am ¤å³¹¥DÃD: |
|
|
violetlkk ¼g¨ì: | Ruey ¯u§Q®`
³s¦b¸ê®wºôªº¸ê®Æ³£§ä±o¨ì
¨ØªA,¨ØªA...
²{¦b·sª©ªºpostgresql
¥unserverºÝ»PclientºÝªº½s½X³]©w¨S°ÝÃD,¤¤¤å¦r´N¨S°ÝÃD
¤]¤£·|¦³'¥\','³\'...µ¥°ÝÃD |
1.¸ê®wºô³oºô¯¸,§Ú«Ü¦´Nª¾¹D¤F.¦Ó¥Bºô§}©ñ¦b³o¸ÌÀY
±`¥Îºô¯¸¾ã²z---921008
http://vfp.sunyear.com.tw/viewtopic.php?t=80
2.¦pªG§A¤]ª¾¹D¤p§Þ¥©ªº¸Ü,¦ó¤£¤½§G¤@¤U.§Kªº¦³¨Ç¤H§ä¦n¤[.
3.PqSQL¥Ø«eÁÙ¬O¥¼¤ä´©Windows.³o¹ïWindows¤ñ¸û¼ô±xªº¤H.
¸û¬°¦YÁ«.©Ò¥H§Ú«Øij¨Ï¥ÎFirebird,¦³Freeª©¥»/²³æ©ö¥Î/¹B§@éw/
ºûÅ@¦¨¥»§C/²³æ§Ö³tªº¦w¸Ë/¸ó¥»O/¦hºØºô¸ô¨ó©w...
(¶¶«K¥´¼s§i).¾A¦X¤¤¤p¥ø·~.¨Ï¥Î¤H¼Æ¤£¦h,¥B¤£»Ýn¥hºûÅ@ªº¨t²Î.
¦pªG§A¸ò¨º¦ì¸ê®wºô¯¸ªø¤@¼Ë¸ê®Æ®w¦³¦nGB¥H¤Wªº¸Ü.
¨Ï¥ÎPqSQL¬O¤£¿ùªº¿ï¾Ü. _________________ #############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~ì¨Ó©¯ºÖ¨º»ò²³æ!!
¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
############################# |
|
¦^³»ºÝ |
|
|
violetlkk
µù¥U®É¶¡: 2003-06-21 ¤å³¹: 82 ¨Ó¦Û: kaohsiung
²Ä 4 ¼Ó
|
|
¦^³»ºÝ |
|
|
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|