Mysql CHAR vs VARCHAR Post: 302144157

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to replace any char with newline char.

Hi, How to replace any character in a file with a newline character using sed .. Ex: To replace ',' with newline Input: abcd,efgh,ijkl,mnop Output: abcd efgh ijkl mnop Thnx in advance. Regards, Sasidhar

2. Programming

Adding a single char to a char pointer.

Hello, I'm trying to write a method which will return the extension of a file given the file's name, e.g. test.txt should return txt. I'm using C so am limited to char pointers and arrays. Here is the code as I have it: char* getext(char *file) { char *extension; int i, j;...

3. UNIX for Advanced & Expert Users

sorting of varchar columns

Hi , I need to sort a file based on multiple columns All the columns are of varchar type can any one give me the command to sort for varchar columns? Thanks

4. Programming

concat const char * with char *

hello everybody! i have aproblem! i dont know how to concatenate const char* with char const char *buffer; char *b; sprintf(b,"result.txt"); strcat(buffer,b); thanx in advance

5. Programming

error: invalid conversion from �const char� to �char�

Compiling xpp (The X Printing Panel) on SL6 (RHEL6 essentially): xpp.cxx: In constructor ‘printFiles::printFiles(int, char**, int&)’: xpp.cxx:200: error: invalid conversion from ‘const char*’ to ‘char*’ The same error with all c++ constructors - gcc 4.4.4. If anyone can throw any light on...

6. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

7. Programming

Invalid conversion from char* to char

Pointers are seeming to get the best of me and I get that error in my program. Here is the code #include <stdio.h> #include <stdlib.h> #include <string.h> #define REPORTHEADING1 " Employee Pay Hours Gross Tax Net\n" #define REPORTHEADING2 " Name ...

8. UNIX for Beginners Questions & Answers

How to get number on file exclude varchar?

hallo, yould you guys help me? im using bash script i have file getnumber.csv cat getnumber.csv 234198 654639 eht4v4 453nbddme 43 455fr i try this cat getnumber.csv | sed 's/*//g' but the result is : 234198

LEARN ABOUT PHP

sybase_fetch_row

SYBASE_FETCH_ROW(3)													       SYBASE_FETCH_ROW(3)

sybase_fetch_row - Get a result row as an enumerated array

SYNOPSIS

       array sybase_fetch_row (resource  $result)

DESCRIPTION

       sybase_fetch_row(3) fetches one row of data from the result associated with the specified result identifier.

	Subsequent call to sybase_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.

PARAMETERS

	      o $result
		-

RETURN VALUES

	Returns an array that corresponds to the fetched row, or FALSE if there are no more rows. Each result column is stored in an array offset,
       starting at offset 0.

       Data types

       +-------+---------------------------------------------------+
       | PHP   |						   |
       |       |						   |
       |       |		      Sybase			   |
       |       |						   |
       +-------+---------------------------------------------------+
       |string |						   |
       |       |						   |
       |       | VARCHAR, TEXT, CHAR,  IMAGE,  BINARY,	VARBINARY, |
       |       | DATETIME					   |
       |       |						   |
       | int   |						   |
       |       |						   |
       |       | NUMERIC (w/o precision), DECIMAL (w/o precision), |
       |       | INT, BIT, TINYINT, SMALLINT			   |
       |       |						   |
       |float  |						   |
       |       |						   |
       |       | NUMERIC (w/ precision), DECIMAL  (w/  precision), |
       |       | REAL, FLOAT, MONEY				   |
       |       |						   |
       |       |						   |
       | NULL  |						   |
       |       |						   |
       |       |		       NULL			   |
       |       |						   |
       +-------+---------------------------------------------------+
SEE ALSO

       sybase_fetch_array(3), sybase_fetch_assoc(3), sybase_fetch_object(3), sybase_data_seek(3), sybase_result(3).

PHP Documentation Group 												       SYBASE_FETCH_ROW(3)