return from sql showing squares
<p>if i use sqlite3.exe the text is returned from my tables correctly
however within android i get squares where the spaces are</p>

<pre><code>import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;

import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import android.widget.TextView;

public class SqlLiteHelper extends SQLiteOpenHelper {

    private static final String DB_NAME = "movelist";

    private static String DB_PATH = "/data/data/ packagename /databases/";

    private Context context;

    private SQLiteDatabase DB;

    public SqlLiteHelper(Context context) {
        super(context, DB_NAME, null, 1);
        this.context = context;
    }

    public List&lt;TextView&gt; getTextViews(String charName, int consoleSwitch,
            int textSize, String moveTypeSource) {

        List&lt;TextView&gt; moveList = new ArrayList&lt;TextView&gt;();
        String movesSql = new String();
        String tableName = new String();

        if (moveTypeSource.equals("Grappling")) {
            tableName = "SevenTypedMoves";
            movesSql = "SELECT moveCommand, moveName, moveType, moveDmg, moveEscape, moveProperties FROM "
                    + tableName
                    + " WHERE character_name = '"
                    + charName
                    + "' and moveArt = '" + moveTypeSource + "'";
        }
        DB = getWritableDatabase();

        Cursor movesCursor = DB.rawQuery(movesSql, null);

        if (movesCursor.moveToFirst()) {
            do {
                String moveCommand = movesCursor.getString(movesCursor
                        .getColumnIndex("moveCommand"));
                String moveName = movesCursor.getString(movesCursor
                        .getColumnIndex("moveName"));
                String moveType = movesCursor.getString(movesCursor
                        .getColumnIndex("moveType"));
                String moveDmg = movesCursor.getString(movesCursor
                        .getColumnIndex("moveDmg"));
                String moveEscape = movesCursor.getString(movesCursor
                        .getColumnIndex("moveEscape"));
                String moveProperties = movesCursor.getString(movesCursor
                        .getColumnIndex("moveProperties"));
                Log.e("movename: ", moveName);

                if (consoleSwitch == 1) {
                    // PS3
                    moveCommand = moveCommand.replaceAll("1", "(͹)");
                    moveCommand = moveCommand.replaceAll("2", "(▲)");
                    moveCommand = moveCommand.replaceAll("3", "(X)");
                    moveCommand = moveCommand.replaceAll("4", "(O)");
                    moveEscape = moveEscape.replaceAll("1", "(͹)");
                    moveEscape = moveEscape.replaceAll("2", "(▲)");
                    moveEscape = moveEscape.replaceAll("3", "(X)");
                    moveEscape = moveEscape.replaceAll("4", "(O)");
                } else if (consoleSwitch == 2) {
                    // XBOX
                    moveCommand = moveCommand.replaceAll("1", "(X)");
                    moveCommand = moveCommand.replaceAll("2", "(Y)");
                    moveCommand = moveCommand.replaceAll("3", "(A)");
                    moveCommand = moveCommand.replaceAll("4", "(B)");
                    moveEscape = moveEscape.replaceAll("1", "(X)");
                    moveEscape = moveEscape.replaceAll("2", "(Y)");
                    moveEscape = moveEscape.replaceAll("3", "(A)");
                    moveEscape = moveEscape.replaceAll("4", "(B)");
                }

                String s = "|" + moveName + ": " + moveCommand
                        + " |Positioning: " + moveType + " |Escape: "
                        + moveEscape + " |Properties: " + moveProperties;

                TextView Move = new TextView(context);
                Move.setText(s);
                if (textSize == 1) {
                    Move.setTextSize(20);
                } else {
                }
                moveList.add(Move);
            } while (movesCursor.moveToNext());
        }
        movesCursor.close();

        String footnoteSql = "SELECT footnoteText FROM footnote WHERE charname = '"
                + charName + "' and movesType = '" + moveTypeSource + "'";
        Cursor footnoteCursor = DB.rawQuery(footnoteSql, null);
        if (footnoteCursor.moveToFirst()) {
            do {
                TextView footnoteMove = new TextView(context);
                String footnoteBodyText = footnoteCursor
                        .getString(footnoteCursor
                                .getColumnIndex("footnoteText"));
                String footnoteText = String.format("FOOTNOTES: \n%s",
                        footnoteBodyText);
                footnoteMove.setText(footnoteText);
                moveList.add(footnoteMove);
            } while (footnoteCursor.moveToNext());
        }
        footnoteCursor.close();

        DB.close();
        return moveList;
    }

    public List&lt;String&gt; getTypes() {
        List&lt;String&gt; types = new ArrayList&lt;String&gt;();
        String footnoteSql = "SELECT footnoteText FROM footnote WHERE charname = '"
                + charName + "' and movesType = '" + moveTypeSource + "'";
        Cursor footnoteCursor = DB.rawQuery(footnoteSql, null);
        return types;
    }

    public void createDataBase() throws IOException {

        boolean dbExist = checkDataBase();

        if (dbExist) {
            // do nothing - database already exist
        } else {
            this.getReadableDatabase();
            try {
                copyDataBase();
            } catch (IOException e) {
                Log.e("Error copying database: ", e.toString());
            }
        }
    }

    private boolean checkDataBase() {

        SQLiteDatabase checkDB = null;

        try {
            String myPath = DB_PATH + DB_NAME;
            checkDB = SQLiteDatabase.openDatabase(myPath, null,
                    SQLiteDatabase.OPEN_READONLY);

        } catch (SQLiteException e) {

            // database does't exist yet.

        }

        if (checkDB != null) {

            checkDB.close();

        }

        return checkDB != null ? true : false;
    }

    private void copyDataBase() throws IOException {

        InputStream myInput = context.getAssets().open(DB_NAME);
        String outFileName = DB_PATH + DB_NAME;
        OutputStream myOutput = new FileOutputStream(outFileName);
        // transfer bytes from the inputfile to the outputfile
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myInput.read(buffer)) &gt; 0) {
            myOutput.write(buffer, 0, length);
        }

        // Close the streams
        myOutput.flush();
        myOutput.close();
        myInput.close();

    }

    public void openDataBase() throws SQLException {
        String myPath = DB_PATH + DB_NAME;
        DB = SQLiteDatabase.openDatabase(myPath, null,
                SQLiteDatabase.OPEN_READONLY);
    }

    @Override
    public synchronized void close() {

        if (DB != null)
            DB.close();

        super.close();

    }

    @Override
    public void onCreate(SQLiteDatabase db) {

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

}
</code></pre>

<p>RETURNS:
sqlite:<img src="http://i.stack.imgur.com/Tbw4j.png" alt="SQLITE RETURN"></p>

<p>logcat and emulator screen: <img src="http://i.stack.imgur.com/5Difq.png" alt="logcatreturns"></p>

<p>just wanted to add that the string manipulation being done with .replaceall isnt on the name field at all. and from the output on the screen i can tell its working. PLUS the logcat pic u see was a Log.e placed before all of the manipulation code</p>

<p>also that the db is premade and i get NO errors in logcat when it displays.</p>
