Search found 26 matches: collate

Return to advanced search

Re: Facturas con consecutivos con acceso a varias terminales

... BIGINT(10) UNSIGNED NOT NULL DEFAULT '0', `my_recno` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`my_recno`) USING BTREE ) COLLATE='latin1_spanish_ci' ENGINE=InnoDB
by carlos vargas
Thu Aug 26, 2021 5:22 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Facturas con consecutivos con acceso a varias terminales
Replies: 18
Views: 1782

Re: FWH 16.06: MariaDb/MySql Backup and Restore (Updated 16.08)

... an output such as: DROP TABLE IF EXISTS `clientes`; CREATE TABLE `clientes` ( `id_cliente` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id_cliente`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT ...
by MOISES
Mon Jun 08, 2020 8:11 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 16.06: MariaDb/MySql Backup and Restore (Updated 16.08)
Replies: 48
Views: 20182

Re: Error al grabar con tDolphin

... "CREATE TEMPORARY TABLE IF NOT EXISTS temp_item";  +"( `id` int(11) NOT NULL AUTO_INCREMENT, ";  +"`codarti` varchar(13) COLLATE latin1_spanish_ci DEFAULT NULL,";  +"`detalle` varchar(40) COLLATE latin1_spanish_ci DEFAULT NULL,";  +"`cantidad` decimal(10,2) ...
by FiveWiDi
Fri Aug 16, 2019 4:30 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error al grabar con tDolphin (Solucionado)
Replies: 6
Views: 875

Re: Ordenamiento CH y LL

Así está perfecto...
El abecedario español tiene esas letras.

Si quieres que lo ordene Ch y LL como C y L respectivamente usa: COLLATE='latin1_swedish_ci' por ejemplo...
by xmanuel
Thu Mar 21, 2019 7:33 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Ordenamiento CH y LL
Replies: 6
Views: 1492

backup mariadb - pregunta

... unsigned NOT NULL DEFAULT 0.00, `fecha_real` date DEFAULT NULL, `valor_real` decimal(10,2) unsigned NOT NULL DEFAULT 0.00, `estado` char(1) COLLATE latin1_spanish_ci NOT NULL DEFAULT '', `nota` text COLLATE latin1_spanish_ci DEFAULT NULL, `my_recno` bigint(10) unsigned NOT NULL AUTO_INCREMENT, ...
by carlos vargas
Thu Mar 14, 2019 7:30 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: backup mariadb - pregunta
Replies: 2
Views: 576

Re: Consulta SQL via TDolphin

Gracias por tus datos CM Mis tablas estan creadas como: CHARSET=utf8 y COLLATE=utf8_spanish_ci Como comenté en el primer post tengo el siguiente Browse   REDEFINE XBROWSE oBrwP ID BRW_XBRW OF oDlg AUTOSORT  ;            ...
by MarioG
Thu Jul 05, 2018 8:16 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Consulta SQL via TDolphin
Replies: 17
Views: 2610

Re: Consulta SQL via TDolphin

... DEFAULT CHARSET=latin1 y el campo es un VARCHAR (40) Tambien probé con otra tabla que tengo definida como ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci y obtuve el mismo resultado. Grabo con la funcion SAVE de Tdolphin Espero que te de alguna pista
by cmsoft
Thu Jul 05, 2018 3:11 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Consulta SQL via TDolphin
Replies: 17
Views: 2610

ADO anchura campos numéricos

... SQL que creó la tabla, como ejemplo : CREATE TABLE `reembols` ( `ID` INT(11) NOT NULL AUTO_INCREMENT, `SERIE1` VARCHAR(2) NULL DEFAULT NULL COLLATE 'utf8_spanish_ci', `TALON` BIGINT(20) NULL DEFAULT NULL, `SERIE2` VARCHAR(3) NULL DEFAULT NULL COLLATE 'utf8_spanish_ci', `NUMERO` BIGINT(20) ...
by gmart1
Tue Jun 26, 2018 4:57 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ADO anchura campos numéricos
Replies: 4
Views: 909

Re: Seek en XBrowse con Dolphin texto con Ñ

Gente:
Quizas no me exprese bien; pero yo, sin leer las particularidades de la collate, selccioné: latin1_spanish_ci. Y tanto el orden como la búsqueda resultan correctas
Uso TDophin, MariaDb y xBrowse
by MarioG
Thu Aug 18, 2016 10:22 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Seek en XBrowse con Dolphin texto con Ñ
Replies: 58
Views: 12314

Re: Seek en XBrowse con Dolphin texto con Ñ

Estimado; Tengo definida así una tabla con apellidos y nombres: (aunque la seleccione a sentimiento :oops: ) COMMENT='Tabla de Tutores' COLLATE='latin1_spanish_ci' ENGINE=InnoDB El orden es correcto, y la búsqueda responde (uso MariaDB) http://i795.photobucket.com/albums/yy237/MLimonG/seekinc.jpg
by MarioG
Tue Aug 16, 2016 1:29 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Seek en XBrowse con Dolphin texto con Ñ
Replies: 58
Views: 12314

Re: Seek en XBrowse con Dolphin texto con Ñ

... above order does not appear to be correct. The order should be CAMISA CANDADO CANILLA CAÑA CAÑO CANOBOTE This is because utf8_general_ci does not collate your data correctly. You will get correct collation if you use utf8_spanish2_ci or utf8_spanish_ci or latin1_spanish_ci For me incremental seek ...
by nageswaragunupudi
Mon Aug 15, 2016 8:41 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Seek en XBrowse con Dolphin texto con Ñ
Replies: 58
Views: 12314

Re: Collate Copies

Ok,
I will try next year!
Many thanks Enrico
by MarcoBoschi
Wed Dec 30, 2015 10:07 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Collate Copies
Replies: 3
Views: 626

Re: Collate Copies

Marco,

try

Code: Select all  Expand view
PRNSETCOLLATE( lCollate )  --> lSuccess


EMG
by Enrico Maria Giordano
Tue Dec 29, 2015 4:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Collate Copies
Replies: 3
Views: 626

Re: Collate Copies

I have this problem using an old program Visual Obiect and Report Pro too!
by MarcoBoschi
Tue Dec 29, 2015 2:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Collate Copies
Replies: 3
Views: 626

Collate Copies

Hi to all! How do I fix this code for printing 2 copies and collate copies ? #include "fivewin.ch"#include "report.ch"FUNCTION MAIN()LOCAL oPrnLOCAL oFnt1  PRINT oPrn                 ...
by MarcoBoschi
Tue Dec 29, 2015 2:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Collate Copies
Replies: 3
Views: 626
Next

Return to advanced search